Creating a timer in DOMO
I am trying to set up an ETL or logic where any time a new incidence happens, the clock resets.
Problem statement would be - How many days can a company go without recording any incidences being recorded. Once the incidence happens, the days resets.
Best Answer
-
Hi @shreeyab, If you are looking for a counter for days, it would be a beastmode or formula like this:
DATEDIFF(CURRENT_DATE(),`yourDateField`)
If you'd like more detail, it would be something like this:
CASE WHEN ((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600) < 24
THEN DATE_FORMAT(TIMEDIFF(NOW(),`yourDateField`),'%k hrs %i mins')
WHEN ((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600) >= 24
THEN CONCAT(ROUND((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600),' hrs')
ENDIf I solved your problem, please select "yes" above
1
Answers
-
Hi @shreeyab ,
How are you gathering the inputs of when an incident happens?
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
Hi @shreeyab, If you are looking for a counter for days, it would be a beastmode or formula like this:
DATEDIFF(CURRENT_DATE(),`yourDateField`)
If you'd like more detail, it would be something like this:
CASE WHEN ((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600) < 24
THEN DATE_FORMAT(TIMEDIFF(NOW(),`yourDateField`),'%k hrs %i mins')
WHEN ((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600) >= 24
THEN CONCAT(ROUND((UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP((`yourDateField`)))/3600),' hrs')
ENDIf I solved your problem, please select "yes" above
1 -
How you solve this will depend on your dataset and if you're recording individual days if they pass or fail or just the failures. Do you have some sample anonymized data to help illustrate this for us?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 95 Manage
- 92 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive