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

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.