Skip to main content
Question

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

  • February 20, 2023
  • 2 replies
  • 9 views
denise.kruge12
Level 7
Forum|alt.badge.img+15
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

    2 replies

    G
    Level 12

    I think this will work

     

    FILTER DAY(TIMESTAMP_COLUMN()) = DAY(TODAY() AND HOUR(TIMESTAMP_COLUMN()) = 5

     

    HTH

    denise.kruge12
    Level 7
    Forum|alt.badge.img+15

    Thank you, it worked.

    Community Code of ConductAccessibility statement