Creating a timer in DOMO

shreeb
shreeb Member
in Magic ETL

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

  • ColemenWilson
    ColemenWilson Coach
    edited January 2024 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')
    
END

    If I solved your problem, please select "yes" above

Answers

  • DashboardDude
    DashboardDude Coach

    Hi @shreeyab ,

    How are you gathering the inputs of when an incident happens?

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • ColemenWilson
    ColemenWilson Coach
    edited January 2024 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')
    
END

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach

    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!**

Categories