Accepted Solutions
.png "Former Employee"){kind=icon}
For the dynamic filter I was able to get it to work using 'evaluate' or 'search' filters
As you can see below for an 'evaluate' filter the preview is correctly resolving to '2020' which (in my example) is now()'s current year 2024 minus 4 = 2020.
This would not work on a 'Date' field though. I had to use it on a year field which was generated in the load script using something like this: Year([OrderDate]) as OrderDateYear
You can do a year range with a two part filter like this:
This filter ended up filtering my report to the years from between 5 and 6 years ago (in my case years 2018 and 2019 but not 2020+).
For the dynamic filter I was able to get it to work using 'evaluate' or 'search' filters
As you can see below for an 'evaluate' filter the preview is correctly resolving to '2020' which (in my example) is now()'s current year 2024 minus 4 = 2020.
This would not work on a 'Date' field though. I had to use it on a year field which was generated in the load script using something like this: Year([OrderDate]) as OrderDateYear
You can do a year range with a two part filter like this:
This filter ended up filtering my report to the years from between 5 and 6 years ago (in my case years 2018 and 2019 but not 2020+).
