Need variable past/future daily date range with ability for user to adjust
I have a number of cards where I need to present daily data with a range of past and future dates. I've found that I can easily fix the date range, and this then still gives users the ability to modify the dates when using the card. This last part is where I am having trouble, as I know I can use a beast mode to create a rolling past/future date range (see example below), but when I do that, it eliminates the ability for a user to then make adjustments to view dates outside of that range.
/*Plus/Minus 60 days*/
case when (DATEDIFF(`APPOINTMENTDATE`, CURRENT_DATE())<=60) and (DATEDIFF(`APPOINTMENTDATE`, CURRENT_DATE())>=-60) then 'Include'
When the dates needed are all historical or all future, the ability to modify by a user still exists. It's only when it includes the past and the future that I run into this difficulty.
Thanks for any help you can provide!
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board