2 Replies Latest reply on Sep 30, 2016 12:36 PM by Dhanashree Arole

    Filter - Previous day

    Vishal D

      I have a field 'Report Date' from the datasource.


      In the worksheet I want to filter the data for 'Report Date' = todays date -1 (previous date)


      How can I create this filter? Do I create a calculated field or directly right filter logic in filters pane/mark?

        • 1. Re: Filter - Previous day
          Ivan Young

          Hi Vishal,

          You can try something like the formula below.  Drag to filters and set to True.



          [ReportDate] = DATEADD('day',-1,TODAY())

          • 2. Re: Filter - Previous day
            Dhanashree Arole



            It entirely depends on your preference.


            One of the ways is to use RELATIVE option that lets you pick PREVIOUS DAY and anchor it relative to desired day.



            This is an advanced feature that will pop out when you drag your dimension Report Date to Filter section. Be careful to choose Relative and then configure rest of the settings per your requirement.


            It's fun to create reports that can be anchored for batches depending on LAST and NEXT days values.






            1 of 1 people found this helpful