Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30.
Thank you
Page 1 / 1
Hi Denisa,
I am sure there is a better way to go about it but you could try something like:
filter TIME("case_table"."case_start_time") = DD.MM.YYYY HH:mm
I found this statement in the examples section of the component filter.
Regards,
Kashif
Thank you Muhammad, I need the formula to update daily so I need to use TODAY()-1 or something like this for yesterday, and not hard coded dates.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.