How to limit data so that is is greater than today
Best Answer
-
You can't enter a formula in the "Limit Data" on the date in the card. This would be a great idea to post in the Idea Exchange though!
You would have to create a Beast Mode calculation and use that as a filter.
CASE WHEN `DATE` >=CURDATE() then 1 else 0 end
and then just add that to the filters area and filter for 1.
1
Answers
-
You can't enter a formula in the "Limit Data" on the date in the card. This would be a great idea to post in the Idea Exchange though!
You would have to create a Beast Mode calculation and use that as a filter.
CASE WHEN `DATE` >=CURDATE() then 1 else 0 end
and then just add that to the filters area and filter for 1.
1 -
This will work, thank you.
0
This discussion has been closed.
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive