GitHub user FrancescoCastaldi created a discussion: Is it possible to compare chart values between two different time periods (current vs past) in a Superset dashboard?
Hi everyone, I'm working on a BI dashboard using Apache Superset and I'd like to implement a **time comparison feature** that allows users to compare metric values between two different time periods directly within the charts — for example: - **Current period vs previous period** (e.g., this month vs last month) - **Current period vs same period last year** (YoY comparison) - **Any two arbitrary time ranges** selected by the user Some specific questions: 1. Does Superset natively support time comparison in charts (e.g., showing both the current value and the past value side by side or as a delta/percentage change)? 2. Are there specific chart types that support this better than others (e.g., Time-series, Big Number with Trend, Table)? 3. Is it possible to configure a **"comparison offset"** (like `-1 year`, `-1 month`) at the chart or dataset level? 4. Can this be achieved through **custom SQL** in the dataset or via Superset's built-in time comparison controls? 5. Are there any known limitations or caveats when using time comparison with filters or cross-filtering? Any examples, pointers to documentation, or sample configurations would be greatly appreciated! Thanks in advance. GitHub link: https://github.com/apache/superset/discussions/40122 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
