Filtering out last 7 days of data vs. 7 days prior

I am trying to create a filter that will allow me to view the last 7 days of production data and then be able to compare that to the 7 days prior to that. I have attempted "If" statements using "datediff" but have not had any luck getting it to work. I have also tried the Property Control function but I am unsure if I did it wrong because nothing happened when I selected the options I created. I can filter by date but wanted to see if there is a more efficient solution.

1 Comment

Can you share some sample data?

Vidya Sagar - Apr 09, 2018 - 1:53pm ::
+ Add a Comment

(1) Answer