Can anyone point me in the right direction of how to select a filter that only captures the last year of records? There is the ability to filter the last 12 months but that includes dates for the current year as well.
It would be helpful to have the option like the first example in the picture that allows anything for the current year to be filtered. So in my case I’d have two filters that say “YTD” and “Last Year”. That way I don’t have to continually go into an application and change the filters from 202x to 202y each year.
I’ll look into making this a simple option. it’s a bit tricky to to categorize it (unless we put it under the ‘is’ option. So when you choose ‘is’ you can either put in a static date or some options like: last year, next year.
Either way you can accomplish this without having to redo this every year by adding two filters together.