Reports can be grouped in several ways. They can be group by which period of time they are shown in as well as how each measurement object is grouped within the report. Not all reports in the system support all the grouping, but most of them actually do.
Interval groupings
Time | The result is shown by the time of day that the event occurred. If you make a report for a complete month then the row for the period 08:00 contains all the data for 07:30 to 08:00 under all days that month. |
Date | Each row contains the data for a date e.g. 2010-01-01 Monday. |
Week | Each row contains a summary for each year's week ex. 2013 W1 contains a summary of all calls that occurred during the 2012 first week This grouping is changed from previous releases. See the respective version of the documentation for a description. |
Weekday | Each row contains data for a day of the week e.g. Monday where all data for Mondays in the report is aggregated in this row. |
Month | Each row contains data for a month e.g. January where all data that occurred in January month is aggregated. |
Quarter | Each row contains a summary for each year's quarter as 2013 Q1 contains a summary of all calls that occurred during the 2013 first quarter. This grouping is changed from previous releases. See the respective version of the documentation for a description. |
Year | Each row contains all data that occurred in that year. |
Year & month | Each row contains data for a month of a particular year e.g. 2010 January. |
Note that if you choose to create a report for the period 2010-01-01 to 2010-01-31 and select the year grouping the result will contain a row for 2010, but the values for that row will only contain the data that has occurred within the reporting period. This is the same for all the interval groupings.
The same case applies to the period of the day. If you create a report that should contain data from 2010-01-01 to 2010-12-31 between 07:00 and 17:00 and group by year the report row saying 2010 will contain data that has occurred within those hours under that year.
Report groupings
Besides grouping reports based on time, you can group reports based on the containing measurement objects and groups. The following options are available:
Total | The report summarizes data for each interval in one row. Ex: |
Objects | The report shows one row for each measurement object and interval.Ex: If measuring the period 2009 to 2010 for measurement objects A and B the result would be. |
Groups | The report shows one row for each group and interval. Ex: If measuring two days for the groups G1 and G2 the result would be. |
Groups and objects | The report shows one row for each group and child object(s). Data is accumulated upwards so that data for child object rows are also added to the parent row. Can consist of parent and children in multiple levels. |
Important information about groupings
Note that if you chose to group by total or by collection point and selects two or more groups that contain the same measurement object (same id) the report will only count these measurement objects once, so the total row will show the actual number of events.
But if Group A contains Measurement object 1111 and Group B also contains Measurement object 1111 and a report is created grouped by Group or Measurement object the values for 1111 would be counted twice in the total row. Each row would show the actual values but the total row will show a value that has counted 1111 twice.
Read more about overlapping groups in the section groups.