RollupQuestions
Shows rolled up individual stats information for a survey.
Select
You must specify the survey Id for this view to see roll up stats for the survey. The adapter will execute other filters client-side in memory.
For example, the following query is processed server side:
SELECT * FROM RollupQuestions WHERE SurveyId = '1231231'
Columns
Name | Type | Description |
SurveyId | String | The Id of the survey. |
QuestionId | String | The Id of the question |
ResponseCount | Integer | Number of people which answered by selecting this choice. |
ResponseTextCount | Integer | Number of people which answered by writing in a text. |
ChoiceId | String | The Id of the response. |
Other | Boolean | Whether the selected choice was an other response. |
Ordinal | Int | The number of the order this choice appears in the list of choices. Ordinals are used to get a meaningful representation for stats like maximum, minimum, average, median, and standard deviation. |
Max | Double | The maximum value of the ordinals of the answered choices. |
Min | Double | The minimum value of the ordinals of the answered choices. |
Mean | Double | The average value of the ordinals of the answered choices. |
Median | Double | The median value of the ordinals of the answered choices. |
Std | Double | The standard deviation value of the ordinals of the answered choices. |