Skip to Content

Metrics

Split a chart into series

Split a chart's measure into one series per value of a column, and let viewers pick the column.

This is the Group By in the Add filter menu above the chart. It sets the chart’s series. The Group By in the Query toolbar is a different control: it groups the rows of the query. See Joins, filters, sort and group by.

Before you start

  • The metric has results.
  • The chart is not Pivot Table V2, Pivot Table V3, Sankey, Bubble V2, Combo or Horizontal Combo.
  • Drill down and the comparison filter are off.

Steps

  1. Open the metric in the metric builder.

  2. Select Add filter above the chart.

    Metric builder chart area with Add filter highlighted above a bar chart
    Add filter sits at the top left of the chart, under the Chart, Table and Query tabs.
  3. Select Group By.

    Add filter menu open with Metric Filters, Switch X Axis, Switch Y Axis and Group By, Group By highlighted
    Group By is the last item in the Add filter menu.
  4. In Series Column, select the column to split by.

    Group By dialog with Series Column set to product category, highlighted
    Series Column sets the column that splits the bars into series.
  5. Select Save.

The chart shows one series for each value of that column.

Let viewers pick the series column

  1. In the Group By dialog, turn on Dynamic Options.

    Group By dialog with the Dynamic Options switch highlighted
    Dynamic Options lets viewers pick the series column.
  2. In Series Column, select each column viewers can pick from.

  3. Optional: in Alias for Ungrouped, enter the label for the choice with no split, for example All.

  4. Optional: turn on Enable the Clear Option so viewers can remove the split.

  5. Select Save.

On a Hybrid Bar chart, the dialog also has Stack Measures. Select the measures to stack.