Date range comparative analysis
- 05-26-2025
hey HQ_Dev_Prod ,
thanks for sharing the full details.
From the understating, it's not a comparative dashboard where users can filter 2 custom range of Date filters. instead, users would like to filter on a Period meaning, Single date Filter.Assuming using a Revenue as Metric, Users would like to see the KPI for Revenue for the entire period, and break by the Revenue for multiple Dimensions.
Additionally, users would like to be able to Review the Growth from the First Period (i.e. Jan) to the Last Period (i.e Jun) in respective to the Date filter. meaning if the range is different (Jan - March) the Growth calculation is Rev(March) / Rev(Jan)
For getting this, it's require to use a filter measure (not the plugin) to Get the Minimum and Maximum of Date according to the date Period.
Please find an example on behalf of the Sample Retail Datasource:
- Open the Sample Retail datasource and add Custom Column: Month_year column to Dimdate table as the following calculation: getyear(date) * 100 + getmonth(date)
- Import the dash file
- Review the Dashboard Formula related for Min and Max:
It's using Top/Bottom 1 to filter the Max(Month_year)
- Try to apply the same on your side
Dashboard Output:
- Red Present Min Period
- Green Present Max Period
- Total Order Revenue relate to the entire period
Please note that it's a sample use case and may not work across multiple use case
Best regards
- Open the Sample Retail datasource and add Custom Column: Month_year column to Dimdate table as the following calculation: getyear(date) * 100 + getmonth(date)