Group by Fields
Group by fields enable the metric to segregate data and perform the same calculations for each grouping defined by a group by field.
For example, a metric that calculates the average response time for an organization might group the results by country, thereby calculating the times for each country separately.
In the following example, Country is a group-by field, and Average is an aggregation field.
When incoming data has a new value for Country, a new metric instance is created. When incoming data has a value for Country for which a a metric instance already exists, then that metric instance is updated.
Multiple Group By Fields
You can use any number of group by fields to create more granular levels of aggregation. Suppose Country and City are group by fields. A new metric instance is created for each unique combination of country and city values:
For example, if a new record arrives for JAP/TOK, and a metric instance exists for that combination, the metric value is updated to show the new Average value for that city.
Group by fields are used to display categories in charts. Display of multiple categories is supported for table type charts. For more instructions, see Configuring a Multi-Category Table Chart.