How to filter the records for computing the metrics for metric block

🧩 Low-Code Development
#1

I am trying to filter on date fields to get count of last 24 hours record. There is not enough documentation to accomplish this. I am trying with the below statement in the filter field of the metric block, but no luck.

DATE(update_dt) > DATE(modDate(DATE(update_dt), “-1”))

Appreciate any help i can get here.

Regards

#2

Hello, sorry for such a late response

Some SQL syntax is supported, in this case you could use:
DATE(updatedAt) > (NOW() - INTERVAL 1 DAY)

This would fetch all the records that were updated in the last 24 hours.
We should and will update documentation regarding such cases

Thank you for your question

1 Like