GroupBy

Description

 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.

Input

 Time Series – multiple (Multiple time series.)

Parameters

 Aggregation

Mandatory, list_single_selection (Group by aggregation function.)

 

 Group By

Mandatory, token (Group by fields.)

Output

 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:

groupBy0.png

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

groupBy1.png

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:

groupBy2.pnggroupBy3.png

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