Creating an Aggregation
- Carl Richter
- Tobias Kienlein
An aggregation is a mathematical function where the values of multiple submissions are grouped together to form a single or multiple summary value.
Example of Enrolments:
As seen below in the data collection Enrolments each submissions holds a value about the Total Students that went to the specific school in a specific year. With an aggregation you can for example return the value of the total number of students that were enrolled in the year 2012.
An aggregation is configured in the Aggregation Editor, which will open up when you are configuring the dashborad items Number, Chart and Text.
Name | Function |
|---|---|
Data Collection | Dropdown of all data collections in the MIS |
Name | Name of the aggregation |
Description | Description of the aggregation |
Single Result | Enables/ Disables if aggregation should return one or multiple result |
Filter By Users' Surveys | ??? |
Aggregation Template | Dropdown of preconfigured aggregations |
→ Number of submissions | Counts submissons of a data collection |
→ Number of submissions by question | Counts submission grouped by a specific question (e.g. selection question, number question, text question, etc.) |
→ Number of unique values of submissions | Counts unique question values of all submissions |
→ Sum of number question values | Sums the value of a specific number question of submissions |
→ Sum of number question values by question | Sums the value of a specific number question of submissions grouped by a specific question (e.g. selection question, number question, text question, etc.) |
Select a data collection from which the data will be aggregated via the dropdown list,
insert a Name and a Description of the aggregation,
select if the aggregation should return a single or multiple results,
select an Aggregation Template from the dropdown (described above) and
click Preview to see the preliminary result.
If the result is correct, click Save As New.
When editing an existing Aggregation you have the possibility to simply save it or also save it as new. This might be helpful when creating multiple very similar aggregations.
Â