Current Date Filter
ccpincombe
⚪️
in Charting
Can you filter date to be less/greater than today without manually updating the date range filter?
1
Best Answer
-
@ccpincombe you can accomplish this by writing a beastmode formula and then filtering on the formula.
Example
CASE
WHEN TableDate > CURDATE() THEN 'Greater'
WHEN TableDate < CURDATE() THEN 'Less'
END
Then you would filter either one and never have to update manually.
Thanks,
Johnf
4
Answers
-
John,
Great suggestion! Definitely worked.
Would love if it didn't require a beast mode and were able to choose this as a filter option!
1
This discussion has been closed.
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部