beast mode question

Abe
Member
in Beast Mode
Hello everyone,
I'm having an issue trying to get this beast mode calculation validated.
We have tickets that is suppose to be updated but we want to track tickets that are not updated within 4 hrs.
And we want a color change when ticket is about to breach 4hrs with no update.
I wrote this but getting syntex error.
if DATE-(`Last_Update`)>=4 `Hours`then 1 else 0
I removed hours and replaced with '' but not getting any data.
Any assistance is greatly appreciated.
Tagged:
0
Comments
-
Use CASE WHEN:
CASE WHEN
Last_Update
>= NOW() - INTERVAL 4 HOUR THEN 1 ELSE 0 ENDIf I solved your problem, please select "yes" above
1 -
Thank you for the assistant @ColemenWilson !
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive