Hello, i have created a parameter with 3 static values 1, 2, 3
I want to use this parameter as a filter to show Last N days in a chart where only the Last n days will gets displayed in the chart. I have created a calculation field and it is working using a max(mydate - parameter). However, i am not able to select this calc field in a filter to achive mydate > calc field
you can’t create the filter?
What if creating a new field.
Ifelse(mydate > calc field,1,0)
And use the 0/1 field in a filter.
BR
The issue is you cant capture and use that calc field in the filter. However i found a solution. You can use the same parameter approach like i was tryibg to do plus use the last n filter from mydate
1 Like
Perfect. If you found a solution, could you please solve the topic?