Hello, I have 2 questions and I think they are connected somehow...
1) I have a radio button filter for end users where they can chose year. I've found out that if I put Year in expression without "=" sign, than I have options (2022, 2021,2020, 2019 - all years that I have in my DB) and if I chose e.g. 2021 button, I can see data in tables for 2021,2020, 2019. If I put "=" sign in expression, than in my tables I can see only 2021, instead of three years. Why? Is there a better and more obvious way to write this expression?
2) I need to write an expression to show in my radio button filter last 4 years. If I'm writing an expression with if(if year>=year(today())-4 and year<=year(today())), than if I chose 2021, it shows me only 2021 year in my table, instead of 2021, 2020, 2019. Could you please help me to write an expression in my filter to show last 4 years.
