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.

Attachments

AttachmentSize
Image icon capture.png24.09 KB

2 Comments

Hello Watt01,

Thank you so much. It worked !!!!!!!!!

God Bless You.

zaw.zaw - Oct 11, 2017 - 1:38am

You are nearly there - you just need to use the 'desc' option:

 

DenseRank([fw_int],"desc")<=4

j_w - Oct 11, 2017 - 1:35am
+ Add a Comment

(1) Answer

Login