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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive