Latest 5 weeks of data

[stevejones1]

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!

[Anonymous]

what about chart sort the QtrWk dim as expression

Descending order of QtrWK

[stevejones1]

=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.

[jcampbell474]

Sorry, I initially uploaded the wrong app.  Please try this.

=Count({1<CaseType ={'TS'},Indicator = {'Created'},YrQtrWkRank = {"=Rank(YrQtrWkRank)"}>}DISTINCT(CaseNumber))

[stevejones1]

Looks like using this i get all the quarters data , i just want to see for Current quarter , basically rolling 5 complete weeks.

[stevejones1]

Can someone take a look at this ?