GroupBy

Description

 Groups multiple time-series by applying an aggregation function. Choose the property to group by. 

Input

 Time Series: Multiple (Multiple time-series)

Parameters

 Aggregation

Mandatory (the aggregation function; avg / sum / median / std / max / min) 

 

 Group By

Mandatory (Group by property) 

Output

 Grouped Time Series: Multiple 

Available in

 Alerts, Composites, Dashboards 

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

Usage example 

Say you are tracking user sessions in your website. Metrics that measure sessions are often characterized by properties such as Device_Category, Country, Time_zone, Landing_page, and so on. You can use the GroupBy function to sum the number of sessions across the different device types, which are Desktop, Mobileand Tablet, as follows:

groupBy0.png

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

groupBy1.png

Note that this can be executed along more than one property. For example, you can use the GroupBy function to sum the number of sessions across metrics that have both device_type andcountry 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: GroupBy and Group functions serve different use cases, and should not be confused.

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