List widget

A List widget ranks one dimension by a single metric on a dashboard: a row for each value (a campaign, a channel, a subject line), with the metric beside it, sorted from top to bottom.

Rank your campaigns by a metric like Sent Unique, and the ones that reached the most people rise to the top while those falling behind settle at the bottom: a fast read on what’s working and where to look next.

It’s one of the Details widgets. Where a Table shows many metrics across columns and a Comparison sets periods side by side, a List keeps to one metric and ranks it.

How the rows read

Each row is one value of the dimension and its metric over the dashboard’s date range:

• The value and its number: the dimension on the left, the metric on the right.
• A share bar: sized against the top row, so the ranking reads at a glance. The longest bar leads, and the rest fall away behind it.
• Compare and change: with the dashboard’s comparison period on, each row adds the metric for the earlier period and the change between them, green when the number moved the right way, red when it moved the wrong way. Which way is “right” depends on the metric.

Sort by either column: click the dimension heading to order the rows by name, or the metric heading to order them by value, and click again to flip between ascending and descending. A List sorts by the metric, largest first, until you change it.

Cross-filter the dashboard

Clicking a row turns its value into a global filter on the whole dashboard: pick one campaign in the list and every widget narrows to that campaign at once. It’s the same filter you could set by hand, so it appears in the dashboard’s filter bar; click the same row again to clear it. This is what a List does that a static read of the numbers can’t: it’s a way into the rest of the dashboard. On a read-only dashboard, where the filters are locked, rows aren’t clickable.

Set up the widget

You build a List from four choices:

• Dataset: where the rows are drawn from, chosen as a dataset.
• Dimension: the one thing to list, a row per value.
• Metric: the number to rank by. The picker offers only the metrics a List can rank (a plain sum or average), so a calculated or distinct-count metric may not appear.
• Filter: optional, narrows the rows before they’re ranked.

Two more settings shape the display:

• Row limit: the top 5, 10, 25, or all of them.
• Comparison: whether the compare and change columns show when the dashboard is comparing periods.

You set the starting sort here too, though anyone reading the dashboard can re-sort by clicking a heading. Opening and saving the editor work as for any widget; see the Dashboards page.