Forum Discussion
robertocarlos
9 years agoNew Member
dynamic rolling date (last 7 days)
I am simply trying to put a dynamic date filter to show me a filtered result of this table of the last 7 days (Test Date) everytime this report is opened. ...
- 9 years ago
Hey Robertocarlos,
My apologies, I had the less than symbol backwards. It should be <=7 instead of >=7.
Use that calculated column and place it as a page-level filter with it's value set to 'Yes'. This should filter out everything except rows where the Date Column is in the last 7 days.
th3h0bb5
9 years agoResolver II
Hey Robertocarlos,
My apologies, I had the less than symbol backwards. It should be <=7 instead of >=7.
Use that calculated column and place it as a page-level filter with it's value set to 'Yes'. This should filter out everything except rows where the Date Column is in the last 7 days.
robertocarlos
9 years agoNew Member
Thanks th3h0bb5,
It worked.
I wonder though, if there is another way to use the Date Filter directly.. but Thanks so much :smileywink: