Hello together,
I want to build a dynamic filter that can vary depending on when a particular button is clicked. This means I write a variable and update it depending on the button. The filtering also depends on this. Unfortunately, I cannot use the variables created in the view as input for the filter.
Specifically, I have a button called “Process start” and one called “Process end”. Depending on what was clicked, the start of the process in the filtering should not be longer than 12 months ago, or if the end of the process was clicked, it should not be longer than 12 months ago. I'm using this for a diagram.
Unfortunately, the dynamic variables cannot be used in filtering.
Does anyone have an idea? I'm really desperate. Thank you very much and kind regards!