2 by 3 Majority >= Cummulative sum Bucket

[Purushothaman]

Hi @vinieme12 ,

I got stuck in this requirement:

I want the dimension name of Audiencesensetating which is in of 2/3 majority and range sum count.

For example: 

The 2/3 Majority count for 13 is 9. The PG12, falls under 2/3 majority count and Rangesum. Hence I need the PG12 should be highlighted. 

I have attached the QVF

Please help!!

Thank you!

[vinieme12]

Add Below background color expression

= aggr( if( rangesum( above(count(AudienceSensorRating),0,RowNo())) >= (count(total AudienceSensorRating)*(2/3)), red()) ,(AudienceSensorRating,(=Max(SensorRanking),ASC)))

[Purushothaman]

Hi @vinieme12 ,

Is it possible to Highlight only PG12, as it falls between 2/3 Majority Count and RanesumCount

Your help is greatly appreciated. Thanks a lot 🙂

[vinieme12 · Accepted solution]

try below

if (
Min(total aggr( if( rangesum( above(count(AudienceSensorRating),0,RowNo())) >= (count(total AudienceSensorRating)*(2/3))
, SensorRanking ) ,(AudienceSensorRating,(=Max(SensorRanking),ASC)))) = min(SensorRanking) , red() )

[Purushothaman]

Hi @vinieme12 ,

You are genius!!  Yes its working!!!

Thanks a lot for your great help!! Much Appreciated..