Best Of
Re: Creating a timer in DOMO
Hi @shreeyab ,
How are you gathering the inputs of when an incident happens?
Re: Creating a timer in DOMO
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
Re: Remove duplicate unknown comma separated values within a single 'cell'
This is been very useful by the way @rco. Thank you very much indeed.
Re: December 2023 Community Forum Highlights
I'm so honored!! @GrantStowell I keep my thin figure by only eating and breathing Domo.

