Pro Workshop #1: Formula-based period comparisons
Every dashboard ends up needing a period comparison. The concept is simple, the implementation rarely is.
In this first episode of the Pro Workshop series, Christian walks through four approaches with increasing complexity to build period comparisons in ClicData:
– Year-over-Year Column Charts with smart date filtering
– Scorecard Widgets with dynamic percentage change indicators
– Drill Down Tables combining Transact-SQL and ClicData’s native syntax
– Interactive Date Range Pickers with Dashboard Formulas for WoW, MoM, QoQ, YoY, and custom periods
11 minutes. No filler, straight to implementation.
Check out all the formulas available on ProWorkshop video on our Help Center.