Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
This?
yet again, Thanks!!