Report aggregation and grouping examples

It is possible to aggregate certain data within a report, this can be useful when you want to see multiple pieces of information together (see the examples below for more details). It is also possible to group data, to give you more of an overview of information. again examples can be found below.

It is not possible to have multiple count aggregations in a report that use the same field for data. This is because once the field has been grouped for the first count it is not ungrouped again, meaning any subsequent counts will simply reflect the number from the initial count. Therefore it is advised where possible you use columns that are already aggregated. 

For example, if you wanted to aggregate course completion, using both the Number in progress and the Number completed columns from the Course Completion by Organisation report source will work, as these columns already contain an aggregated number.

However, using both the Is in progress? and the Is complete? columns from the Course completion report source with the count aggregation set on them will not work, as the aggregation would be correctly calculated for the first column but then repeated in the second as they use the same field for aggregation. 

Aggregation examples

Assume that the following is the output of my report with no aggregation or grouping turned on:

Comma-separated values: Lists the values from the column in one row.

If the Comma-separated values option is turned on for column two (the courses) it produces:

 CSV without duplicate: Same as CSV, but if Course A is listed twice. This would just show once for the user.

 Count: Instead of listing course names, it would have a count for the column.

 Count unique: Eliminates duplicates from count.

Grouping examples

Dates: Date groupings will group by the date/time format chosen.

Assume that the following is the output of my report with no aggregation or grouping turned on:

To produce the numbers, not the names, of the users accessing the system, set the User Name or ID to a count field and the date field use whatever grouping format required.

User Name (Count) | Last System Access Date (YYYY)

 User Name (Count) | Date YYYY-MM

 User Name (Count) | Month of Year