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?