Tutorial 2: Displaying Metrics in Groups

In the following column chart, all campaign metrics for 301 are grouped by publisher per time sample.
image011.png

How to use the groupBy function:

  1. In the Metrics tab, place the cursor in the blank function node.
  2. Start typing Publishers and select Publishers in the Properties drop-down list.
  3. In the Values drop-down list, select All (*).
  4. Click image005.png at the right of the expression. The image005.png function node appears above.
  5. Place the cursor in image005.png expression node box.
  6. Type groupBy or select groupBy in the drop-down list. A mandatory Aggregation parameter box opens. Options are: Avg, Sum, Median, Std, Max, Min.
  7. In the drop-down list, select Avg.
  8. In the Group By parameter box, select Publishers.

    The expression tree now contains the following nodes:
    image007.png

  9. Click Save. See Saving Metric Expressions

How to create a column chart:

  1. In the Expression Builder toolbar, select image009.png.
  2. In the Display as section, select Column.
  3. In the Stacking section, select Normal.
  4. Click Done.