13 Replies Latest reply on Sep 25, 2018 12:45 AM by James Bills

    How can you filter calculated time periods?

    James Bills

      I view my arrival time data in decades.

       

      These are created by the following calculated field:

       

      IF DAY([ETA]) < 11 THEN "1D"

      ELSEIF DAY([ETA]) < 21 THEN "2D"

      ELSE "3D"

      END

       

      I want to be able to filter to show just the last 2 decades, current decade and the next 3 decades.

      So as of 24/9/18, I would want to show 1D Sep, 2D Sep, 3D Sep, 1D Oct, 2D Oct, 3D Oct

      Can't seem to figure out how to do this. The communities help would be much appreciated!

       

      Thanks,

      James