Monitor last run of datasets
We are looking for a way to monitor the last run of our email datasets. At the moment we are feeding the data through Email either manually send to Domo or via Obiee, however from time to time either someone forgets to upload the data or the automatic upload fails. As a solution, we would like to build a dashboard containing cards to monitor the state of the most important datasets in terms of when was the last upload. I was thinking for beast mode formula comparing the last run ( column is a timestamp) and today, however, for some reason it's not working as it should be with the following example:
(case when DATEDIFF(CURRENT_DATE(), MAX(`_BATCH_LAST_RUN_`)) <= 2 THEN 'true' ELSE 'false' end)
In my head, this should give us "true" if the dataset has been updated in the last 2 days and "false" if it hasn't been updated.
My guess is that there is some kind of problem between current date, _BATCH_LAST_RUN_ ( which is "timestamp" ) and the "2".
I would really appreciate if someone can help me to figure this out.
Thank you in advance!