Group multiple time series by applying an aggregation function. Choose the property or token position to group by. Available aggregation functions are: avg, sum, median, std, max, min.


 Time Series – multiple (Multiple time series.)



Mandatory, list_single_selection (Group by aggregation function.)


 Group By

Mandatory, token (Group by fields.)


 Grouped Time Series - multiple

Available in

 Alerts + Composite + Dashboards

The GroupBy function is among the most commonly used functions in Anodot. Most often, it is used to aggregate multiple metrics by summing them up, or averaging them across one or more properties. Other available aggregation methods for this function are grouping by median, standard deviation, max or min.

For example, let’s say you are tracking user sessions in your website. Metrics that measure sessions are often characterised by properties such as Device_Category, Country, Time_zone, Landing_page, etc. We can use the GroupBy function to sum up the number of sessions across the different device types, which are Desktop, Mobile and Tablet, as follows:


As expected, this function will return a chart with three metric composites:


Note that this can be executed along more than one property. For example, we can use the GroupBy function to sum up the number of sessions across metrics that have both device_type, and country properties:


The GroupBy function is mandatory when you’re interested in creating a composite metric that calculates the ratio between two groups of metrics that are matched in one or more dimensions. For more information and examples, visit the ratioPairs function page.

Important note: the functions GroupBy and Group have similar names, but they serve different use cases, and should not be confused.

Was this article helpful?
0 out of 0 found this helpful