7 Replies Latest reply on Oct 1, 2018 6:20 PM by Olga Pasikova

    How to exclude last N hours from a view?

    Olga Pasikova

      I have a dashboard that updates every 15 mins. I would like to have an hourly view and always exclude last two hours.

      The formula that I use works, but it applies the rule for YESTERDAY, not today.

       

      Here is the formula:

       

      if [transaction_timestamp_minute] < DATEADD('hour', -2, TODAY ()) then  'T' ELSE 'F' END

       

      Here is the data set that I get as a result.. How can I apply it to the today's day?