Hi,
we have an customer satisfaction survey where the customer can give grades to different areas.
I have made an sql query with "FlySpeed SQL Query" like this:
Code:
Select
'Eingangsbereich' As Beschriftung,
Avg(ck05a_rsform_submission_values.FieldValue) As Bericht
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FormId = 14 And
ck05a_rsform_submission_values.FieldName = 'EingangsbereichR'
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Flure und Verkehrsflächen' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'FlurR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Treppenhäuser und Aufzüge' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'TreppenhauserR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Büro und Besprechungsräume' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'BuroR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Sanitärbereiche' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'SanitarbereicheR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Küchen und Kantinen' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'KucheR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Technik und Kelleräume' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'TechnikR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Klassen und Kellerräume' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'KlassenR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'Aufenthalts - und Umkleideräume' As Umkleideräume,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'AufenthaltsraumR' And
ck05a_rsform_submission_values.FormId = 14
Group By
ck05a_rsform_submission_values.FieldName,
ck05a_rsform_submission_values.FormId
Union
Select
'''Sonstige Nutzflächen' As Column1,
Avg(ck05a_rsform_submission_values.FieldValue) As Avg_FieldValue
From
ck05a_rsform_submission_values
Where
ck05a_rsform_submission_values.FieldName = 'SonstigeR' And
ck05a_rsform_submission_values.FormId = 14
After pasting the query above the loading bar of vChart didn't not disappear. Is there something in the query, that vChart didn't support?
In the Attachment i add the Sample Query.
Thx and regards,
Orhan
