Help & DocumentationCreating Basic Metrics and Reports Advanced Reporting OptionsHow to chart only the Top <N> values and Group remaining as 'Other'

How to chart only the Top <N> values and Group remaining as 'Other'

This article describes how to create a Chart that will only display the Top <N> dimension values on a Chart and group the remaining dimensions into a category of 'Other'.

If creating a new chart for your report, see: Develop Report Chart based on the Result Set

1. Access the Report Editor for Selected Report

In this example, we are modifying an existing Chart.

2. Chart Editor displays

  1. Set Include column values to "largest"
  2. Input the number of top values to be included

Save & Publish

3. Chart with all values displayed

4. Chart after changes applied

Note how all values outside of the top 7 are combined as 'Other'.