Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 2 ranks in my data , rank for latest quarter and rank for latest week , how can i write an expression to show chart for past 5 weeks of data and also is there a way that i could reverse the autonumber?
Please help
Thanks!
what about chart sort the QtrWk dim as expression
Descending order of QtrWK
=count({1<Indicator = {'Created'},YrQtrWkRank = {'max(YrQtrWkRank)-5))'},CaseType ={'TS'}>} DISTINCT(CaseNumber))
Can someone help me what wrong in this expression , i am trying to shows data for max 5 values
Attached the app.
Sorry, I initially uploaded the wrong app. Please try this.
=Count({1<CaseType ={'TS'},Indicator = {'Created'},YrQtrWkRank = {"=Rank(YrQtrWkRank)"}>}DISTINCT(CaseNumber))
Looks like using this i get all the quarters data , i just want to see for Current quarter , basically rolling 5 complete weeks.
Can someone take a look at this ?