ratioPairs

 

Description

 Divide pairs of time series

Input

 Multiple time series

Parameters

 None

 

Output

 Grouped Ratio Time Series - multiple

Available in

 Alerts + Composite + Dashboards

The ratioPairs function is among the most commonly used functions in Anodot. Basically, it provides a simple way to divide one (or more) time series in another time series. This is often used for generating composites such as CPC (Cost Per Click) and CTR (Click Through Ratio).

CPC example

The ratioPairs function is created by entering two metric expressions - one in the dividend, and another in the divisor. Here is a quick example of how to set up a CPC composite, based on the division of cost by clicks samples, that are grouped and matched by their country property:

ratioPairs.png

 

A more detailed example 

In Anodot, we use the ratioPairs function to calculate the usage of metrics in each of our customers’ accounts. This is executed by dividing the number of indexed metrics (metrics) in the total number of contracted metrics (max_metrics):

ratioPairs0.png

The expression below returns the division result of each dividend time series by the matching sample in the divisor time series. The GroupBy function is mandatory here, as the two groups of metrics must be matched in at least one dimension. In our example, this allows the one-to-one matching of metrics and max_metrics samples that share the same customer and stack properties. The result of this composite is multiple time series, each one expressing the ratio between metrics and max_metrics for a specific customer and stack combination.

ratioPairs1.png 

Note: the Pairs function is similar to ratioPairs, yet offers additional operations between matching time series samples (multiplication / addition / subtraction). 

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