Forum Discussion

cglowe's avatar
cglowe
Cloud Apps
02-23-2022

Advanced Date Filter - Allow User to Select Different Dates

I have dashboards that I want to be filtered, by default, to current month + previous 12 months, as shown below.  However, I also want end users to have the ability to select a different date range i...
dashboards & reporting
BobF's avatar
BobF
Data Storage
02-28-2022

Hi

I've done something similar, adding a new custom field e.g. "Monthly_Report_Date", based on the date, using a Case statement to build it up. You can add as many values you want. Below shows an example for just 3 values

Case
WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=0 THEN 'Current Month'
WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=1 THEN 'Last Month'
WHEN MonthDiff(CURRENTDATE(),[<Your_Date>])=2 THEN 'Two Months Ago'
END