Tutorial 2: Displaying Metrics in Groups

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

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  at the right of the expression. The  function node appears above.
5. Place the cursor in  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:
   

9. Click Save. See Saving Metric Expressions

How to create a column chart:

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