2 Replies Latest reply on Mar 30, 2017 2:02 PM by Vishal D

    Exclude certain days of data from view?

    Vishal D

      This is how my underlying data is, since I am using 'This Month' relative filter I am getting full month of data(screen shot shows partial month upto 13th).

       

      I want to show data only upto 10th of each month(remove dynamically last 20 days of data from each month). How do I exclude the extra data from view?

       

      Also I have a cumulative calculation so that also should stop at 10th day.

       

      I tried calc field = [Report Date] = DATE(DATEADD('day',-20,TODAY())) and then 'False' but this just eliminates 3/10/17 record. I want to eliminate all records after 3/10/17 (remove dynamically last 20 days of data from each month)