Leaderboards

Rank groups by their exact values in a sorted table instead of a plotted chart.

A leaderboard lists every group in a chart from highest value to lowest and shows the exact number for each one. Use it when the figure is the answer — who is carrying the most work, which workspace closed the most records, which tag comes up most often — rather than the shape of the data over time.

A leaderboard is a presentation style of the bar graph, so it shares the entire bar-graph builder: every group-by field, measures and aggregations, and filters work the same way.

Create a leaderboard

  1. Open a dashboard.
  2. Select Add chart > Leaderboard.
  3. Enter a title.
  4. Under Group by, select the field that defines the rows. You can group by assignee, tag, list, status, date, workspace, or a supported custom field.
  5. Under Measure, select Records to count records or select a numeric custom field, then choose its aggregation.
  6. Select Add filters if you need to limit the records in the chart.
  7. Under Display as, select Number, Percentage, or Currency.
  8. Select Create.

You can also open an existing bar, line, or area graph and switch it to a leaderboard with the Bar / Line / Area / Table toggle.

What each row shows

Every row carries four things:

  • Its rank. Groups with the same value share a rank, and the next rank skips the positions they take up.
  • Its label — the group’s name. Hover a shortened label to read it in full.
  • A bar, sized against the highest value in the chart, so the rows stay comparable at a glance.
  • Its value, in full. Unlike an axis label, a leaderboard never abbreviates a number.

When every value is zero or above, a final column shows each row’s share of the total.

Leaderboard rows ranked by value, with a shared rank and a share-of-total column

Leaderboard with a negative value: no share column, bar growing from the right

How many groups are listed

By default a leaderboard shows all its groups, however many there are. Long lists scroll inside the card.

To keep only the highest-ranked rows, set Limit in the chart builder — Top 5, Top 10, Top 20, Top 50, or any number from 1 to 200. A leaderboard ranks by value on its own, so the limit is available without setting a sort order first. When rows are left out, the card shows Showing top N of M below the rows. See showing only the top groups.

You can also narrow a long leaderboard with a filter, or group by a field with fewer values.

Cross-filtering

Select a row to filter every other chart on the dashboard by that group, the same as selecting a bar or a pie slice. See cross-filtering.

Breakdowns

A leaderboard cannot be broken down into segments. One row per group is the whole format, so there is nowhere to put a second grouping dimension. Use a stacked bar or area chart when you need to show what each group is made of.

Export

Open the chart menu and select Export. Blue emails you a CSV of the records behind the chart — every record the leaderboard counted, not the ranked rows themselves.

Edit a leaderboard

Open the chart menu and select Edit. You can change any setting, including switching the chart back to bars, a line, or an area.