Counting expression result

[hopkinsc]

Hi all,

i have the following expression in a table..

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=4.5,

'Legendary',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=3.5,

'Stella',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=2.5,

'Strong',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=1.5,

'Steady',

IF(

SUM([raw_Overall Score])/COUNT(IF([raw_Overall Score]>0,[raw_Overall Score]))>=0.5,

'Concern'

)))))

Is there a way to count the results of this expression and create a pie chart based on that count.

i.e.

get the count of 'Legendary' ,'Stella','Strong','Steady','Concern' and use it in a pie chart.

Sample attached.

Thanks

[ychaitanya]

Can't we do modelling here , Suggest by placing them in the script which would be the ideal case.

else

we can add the first expression , then use the Column(1) to play on the first expression and increment the counters.

[sunny_talwar · Accepted solution]

This?

[hopkinsc]

yet again, Thanks!!