I'm trying to limit a date dimension by using an "if" statement as follows to allow the last 12-months to be shown in particular chart as follows
I would then exclude null values. I have tried multiple ways of doing this but can't make it work - I can evaluate the formulae e.g. today()-365 in an expression but not making it work in the if statement.
I'm probably missing something really obvious but would be grateful if someone could help me.