Best Of

Domo can’t recognize a filter to show null records. The easiest thing to do is create a new field with a beastmode that is something like this:

CASE WHEN Brand IS NOT NULL THEN Brand ELSE ‘null’ END

Null values will then be replaced with the word Null and you can apply the filter as you would normally.

you could also use IFNULL() or COALESCE() functions to accomplish the same thing.

Hi @shreeyab ,

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

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

This is been very useful by the way @rco. Thank you very much indeed.