Locker Studio custom Filter last 5 Years

[DennisS]

Hi There

i want to show a bar chart with the impressions of the last 5 years. The Bars should be for every year. without having to update the report in locker studio every year.

is there a possibility to set a data Filter for the last 5 years? I only know the way to set a exact Date in the filter, but then i have to update the report every year. i want to just have a bar chart with 5 bars, and that should always me the last 5 years, also in the future.

[lauratilton]

Two ideas:

- you can set a Advanced filter that runs from today minus 1825 days through today, which will give you five years, more or less. But you might be better off with the next option:

OR 

- you can create a source level calculated field (called "Include"?) something like this:
IF(YEAR(TODAY)-5<YEAR(DateField),"Yes","No")
Then set a page or report level filter to only include where Include="Yes"
(you can tweak this as needed if it doesn't give you exactly what you need, you may need to CAST the years as numbers to use the inequality, I'm not sure). But hopefully that gives you an idea.