Ranking disregarding the Dimension

[#1]

Hi All,

Have created a block chart with colouring logic as below.

Rank Clinical Area on basis of Internal Cost Variance and colour the blocks as

1. Top 1/3^rd Clinical Area(with highest internal cost variance) are coloured red, in our case CA6,CA5 and CA3
2. Middle i.e. 1/3^rd to 2/3^rd yellow
3. Bottom 1/3^rd Red

So right now we are dividing all clinical area in 3 groups

I find out max rank here it is 9, 1/3rd of rank i.e. 3 and 2/3rd i.e. 6, than in block chart written logic in background colour to give respective colours

Clinical Area	Internal Cost Variance	Rank
CA1	210	7
CA2	675	4
CA3	7896	3
CA4	31	8
CA5	78971	2
CA6	1000000	1
CA7	345	5
CA8	321	6
CA9	12	9

Issue is user wants to select on Block chart, so when they select a particular clinical Area, ranking goes away and so does Colouring, i have also attached the app , your help would be much appreciated.

So the point is to keep max rank same irrespective of Clinical Area Selection.

Regards,

Anwar

[phaneendra_kunc]

Quick Question...

What does State1 and State2 does in your app? i see you are passing selections of clinical_Area from state2 to state1.

[#3]

I have created Alternate State, in the original app we have filter which only apply to Block chart.

[tresB · Accepted solution]

Try with ALL keyword, like:

=Max(ALL Aggr(rank(sum({<DATE_DT={">=$(vPeriodStart)<=$(vPeriodEnd)"},MEASURE_NAME=,MEASURE_GROUP_ID=,Clinical_Area=,FUNCTIONAL_AREA_NAME=,Quality_Measure=>} MEASURE_NUMERATOR)),Clinical_Area))

[#5]

Thanks Tresesco it worked.