Tutorial 5: The ratioPairs Function

The following example shows how to build a complex expression where the top level function, ratioPairs, operates on two groupBy functions nested at the same level.

The ratioPairs functions divide pairs of time series. The first groupBy expression is the numerator and the second groupBy expression is the denominator. Each groupBy function must have the same values. The denominator must have at least one (1) output metric.

Note: The ratioPairs and divideSeries functions each use a custom template, which contains the entire tree structure required for completing the function expression.

image023.png
How to create a complex function using RatioPairs

  1. From the Navigation Panel, click Metric Explorer.
  2. Click addfunction.png above the expression.
  3. In the Function dropdown list, select ratioPairs.

    The template for the ratioPairs function appears with the necessary expression tree structure:

    ratio-pairs.png

  4. In each groupBy function node:
    • In the Aggregation dropdown list, select the Aggregation type: Avg, Sum, Median, Max, Min, Std
    • In the GroupBy dropdown list, select the property to group by.
  5. In each empty expression node, select property and value pairs, as required.
    The Expression Builder now shows both groupBy functions within the ratioPairs function as completed.
  6. Save the expression (see the relevant saving sections here).