Skip to content

Comparison

The comparison defines the two sides your analysis explains the difference between: Start and End. It is the first setting of an analysis, and every module uses it the same way.

Web app

In the web app, the comparison is a panel of the module settings. Pin it to the story to share it with every module of the story: see Pin settings to the story.

Looker Studio, Tableau, Power BI, Qlik, Excel, Google Sheets, AI Skill

Here, the comparison is in the settings of the visual.

A comparison compares either two segments of a dimension or two metrics.

Most comparisons are two periods (this month against last month) or two segments (France against Germany). For each side, Start segment and End segment, choose:

  • the Column to compare on, for example a date or a country;
  • the Operator and the Value, for example Date between 2026-01-01 and 2026-01-31.

On a date column, pick a preset instead of typing dates: Last day, Last 7 days, Last 30 days, Last 90 days, Last week, Last month, Last quarter, Last year, Month to date, or Previous period for the side you compare against.

A comparison can also carry its own filters, applied to both sides on top of the filters of the analysis.

To compare two metrics of the same rows, for example a budget against the actual figures, switch the comparison to metrics. Each pair maps a Start metric to an End metric under a common name. Start segment and End segment name the two sides as they appear on the charts. Reverse metrics swaps the metrics of every pair.

Revert Start & End swaps the two sides of a comparison.

By default, comparisons are relative: they follow your data. A comparison on the last month keeps showing the last month as new data arrives, without editing the settings. Turn relative comparisons off to keep the exact values you selected: the comparison then stays fixed.

The order of a relative comparison says which end of the data it starts from: Descending (default) takes the most recent value, Ascending the oldest.

Date presets count from a reference date: by default the latest date in your data, or today.

Click Add comparison to analyse another Start / End pair next to the first one, for example this year against last year and against the budget. Remove one with Remove comparison.

In Compare, the waterfall of the second comparison is shown with the first. Right-click the waterfall, then Secondary comparison, to place it Above, On right or as an Overlay. You can also merge the comparison waterfalls on their common bars.