Hi!
I did a work around where I used ranking to get the lastest data and also rolling 30 days.
When the users opens the report it always shows the latest data and if they want they can change the date using a drop down.
I added a parameter to the drop down. The purpose is to store the selected date. I set default values to 1939 and 2039.
I then added a data source filter to do the filtering:
date <= [date parameter]
I also created a numeric variable from the date to use in the rankings.
The BANs and the bar charts shows the latest figures using rank (hope you get the swedish :)):
The line chart shows the rolling 30 days also using rank:
Hope this helps you 🙂
//Fredrik
... View more