Compare

This guide covers the Compare feature — period-over-period comparison available across Query, Funnel, and Data Table reports.

When to Use Compare

Compare overlays a prior time period on your report so you can see how metrics have changed. The current period's data is shown alongside the comparison period's data in the same visualization.

Use Case	Example
Trend detection	Compare this week's event count to last week's to spot growth or decline.
Launch impact	Compare the week after a release to the week before to measure the effect.
Seasonal analysis	Compare this month to the same month last year to account for seasonality.
Regression check	Compare today's error rate to yesterday's to catch regressions quickly.

Comparison Presets

Preset	What It Compares To
Previous Day	Same query, shifted back 1 day
Previous Week	Same query, shifted back 1 week
Previous Month	Same query, shifted back 1 month
Previous Quarter	Same query, shifted back 1 quarter
Previous Year	Same query, shifted back 1 year

Custom Comparison

Choose Date Range Ending At to pick any date. Kubit calculates the offset from your current date range's end to the selected date, then mirrors the same duration backward.

How Comparison Renders by Report Type

Query Reports

Comparison data renders differently depending on the chart type:

Chart Type	Rendering
Bar	Comparison bars appear alongside primary bars in a lighter shade
Line	Comparison line overlaid on the primary line with distinct styling
Stacked	Comparison stacked segments alongside primary
Combo	Comparison bars and lines overlaid on primary
KPI	Comparison value shown below the primary number with percentage change (e.g., "+12%")
Pie	Comparison pie shown alongside the primary pie

Visibility Controls

Once comparison data is loaded, two toggles appear in the chart legend:

Show Measure — toggle the primary (current period) data on or off.
Show Compare — toggle the comparison (prior period) data on or off.

This lets you view just the comparison data, just the current data, or both overlaid.

Funnel Reports

Primary data appears as solid-colored bars.
Comparison data appears as patterned (striped) bars next to the corresponding primary bars.
Comparison step names are prefixed with [Previous] (or [Future] for forward-looking comparisons).
Every primary step is paired with a comparison counterpart. If comparison data doesn't exist for a step, a zero-value placeholder is shown to maintain visual consistency.

Constraint	Details
Modes	Conversion mode only — Frequency and Time to Convert do not support comparison.
Breakdown	Compare works alongside breakdowns — each breakdown value gets its own comparison pair.

Data Table Reports

When comparison is active, each measure column splits into current and previous values displayed side by side.

Toggle Show % Change to add a percent delta column showing the relative change between periods.
Positive changes are highlighted in green, negative in red.

Compare Support Matrix

Report Type	Compare Supported?	Notes
Query — Bar, Line, Stacked, Combo, KPI, Pie	Yes	Full support with visibility controls
Query — Histogram, Treemap, Waterfall, Scatter, Heatmap, Impact	No	Not available
Funnel	Yes	Conversion mode only
Data Table	Yes	With optional % change column
Flow	No	Not supported
Retention	No	Not supported
Significance	No	Not supported

Constraints

Constraint	Details
Include Missing Dates	Compare is not available when "Include Missing Dates" is disabled.
Funnel modes	Only Conversion mode supports comparison — Frequency and Time to Convert do not.
Time granularity	Compare is not available when time granularity is set to All Time in Query reports.

MCP Prompt Examples

"Show me daily event count this week compared to last week"

"Create a KPI of average latency for the last 7 days compared to the previous 7 days"

"Show me the checkout funnel this month compared to last month, broken down by platform"

"Create a data table of event count by model name this week compared to last week, with percent change"