2/3 of Majority match with Rangesum

[Purushothaman]

Hi Experts,

For the below chart my requirement is:

2/3 Majority is 7. 

Now I need to match the 2/3 Majority with the rangesum value which is equal or less than equal max value.

In this case, Rangesum 2+5 is equal to  2/3 Majority which is 7. 

Now I need to highlight the AudienceSensorRating "PG" Since it falls under that range. 

I have attached my QVF as well. 

Anyone, Please help. @ogster1974  if possible please help. Thank you!

[Purushothaman]

@ogster1974

I have managed to do until here:

But I am unable to add another column to show only value of "PG" .

I have attached the latest working file with this.

Please help!!!

[ogster1974 · Accepted solution]

The only way I got it to work was by using ranking on the 2/3 majority.  Perhaps you can leverage that approach.

[Purushothaman]

Can share me the QvF app , if possible. 

please thanks you! 

[ogster1974]

All I did was removed the sensor ranking column and put If(Rank(Column(1))=1, Red(),Green()) in background setting.

Column(1)=to your 2/3 Majority measure.

[vinieme12 · Accepted solution]

alternatively

if(count(AudienceSensorRating)>fractile(total aggr(count(AudienceSensorRating),SensorRanking),2/3) ,1 red() )

[Purushothaman]

@vinieme12 

Thank you for your help!!! it's working. Much appreciated.