Groupings

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. (If the period is set to 30 minutes, this can also be changed by the users) When using time grouping it is always the end time of the period that is printed. E.g. if a report shows 12:00 and the period is 30 minutes then the row that has the value 12:00 describes the period 11:30 to 12:00.
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. If the report spans multiple years each month will be on its own row.

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: 07.00 07.30 08.00
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. 2009 – A 2009 – B 2010 – A 2010 – B
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. Monday –G1 Monday – G2 Tuesday –G1 Tuesday –G2
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. Monday –G1 - G1 Member A - G1 Member B Monday – G2 - G2 Member A - G2 Member B Tuesday –G1 - G1 Member A - G1 Member B Tuesday –G2 - G2 Member A - G2 Member B

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.

Example of overlapping groups

Example on groups

Group A	Measurement object 1
Group B	Measurement object 2

If a report is created on both Group A and Group B and there are one incoming call against Measurement object 1 and the report is grouped by Total the result will be:

Period	Incoming
Total	1
Monday	1

If the same groups are selected but the report is grouped by Group the result will be:

Period	Name	Incoming
	Total	2
Monday	Group A	1
Monday	Group B	1

As described above the total result is different depending on how the report is grouped. The total row always shows a sum of all the other rows in the report.