Grouping brings together or summarizes the related data of a report based on the grouping key.
Group key can be arranged in ascending or descending order, based on group key value or a detail field’s summary value.
For example, if you group population details by region, you can arrange regions by name or by highest to lowest population.
Ad hoc reports support multi-level grouping, for example, you can group the report data by country; within country by states and within states by cities.
Figure 5: Selecting Grouping
Group properties
| Item | Values | Comments |
| Field | Select from list | ‘Group By’ field is the highest priority field selected for grouping. It specifies top level grouping.
‘Then by’ field specifies fields of next priority and level for grouping |
| Order | Ascending
Descending |
Select the order of grouping. Grouping is applied on group key or ranking field |
| Ranking Field | Select from list | Select the field to apply ranking function to decide the order of appearance of groups |
| Ranking Function | Sum,
Avg, Count, Min, Max, Variance, PopVariance, StdDeviation, PopStdDeviation and Distinct functions |
Select the function to apply on the ranking field and find rank.
Ranking functions change based on data type of the ranking field |
| Show When | Specify the criteria | Show When feature helps to specify condition to be met in order to show that group. You can combine multiple conditions with AND/OR operators. Current group details would be shown on the report only if the Show When condition is satisfied |
Actions
| Item | Comments |
Add Group |
Add a new group |
Remove Group |
Remove current group |
Date fields grouping
If you select date type field in Field dropdown, you can also group dates by:
- Minute: Number of the minute indicating the minute of an hour
- Hour: Number of the hour indicating the hour of the day
- Day: Day of the month
- Week: Week number of the month
- Month: Month number
- Quarter: Quarter number
- Year: Number indicating the year
Figure 6: Date fields Grouping