Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am.
The client wants to see a snapshot every day of the cases open at 5:00 in the morning.
Thank you,
Denise
Page 1 / 1
I think this will work
FILTER DAY(TIMESTAMP_COLUMN()) = DAY(TODAY() AND HOUR(TIMESTAMP_COLUMN()) = 5
HTH
Thank you, it worked.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.