Compare
The Compare selector overlays a prior-period line on your chart for period-over-period analysis.
Available comparisons
| Option | Description |
|---|---|
| No comparison | Default — single period |
| Week over week (WoW) | Compare to the same period 1 week prior |
| Month over month (MoM) | Compare to the same period 1 month prior |
| Year over year (YoY) | Compare to the same period 1 year prior |
| Previous period | Compare to the immediately preceding period |
How it works
When a comparison is selected, Celiq runs a second query for the prior period and overlays it on the chart as a dashed line or second bar. The delta percentage is shown in the tooltip.
Limitations
- Comparison requires a date field to be selected
- Works best with Line, Area, and Column chart types