Show only latest 4 weeks in visualization where weeks are incremental for every new week
I have a data set with fiscal weeks and I need to show only latest 4 weeks for every new week rolls in.
I can do with Show/Hide items when the fiscal week is in X-Axis and fiscal week is with Color By in the chart.
However, it will not work when X-Axis is changed to other parameter and Color By with fiscal week.
My 2 cents effort >>> I used the DenskRank function for ranking the weeks so the weeks is like 1,2,3,4,5 and I like to show 2,3,4,5 for week A and when week B comes in I will have 1,2,3,4,5,6 and I need to show only 3,4,5,6 and so on for future weeks.
I would like to process it with "Limit Data Using Expression". How would I do it?
I need some kind help from gurus in this forum. Thanks in advance.
You are nearly there - you just need to use the 'desc' option: