Create a pie chart from the average classification of data

[marthajesicap]

Hello everyone,

Please help me to solve this problem.

I have daily data accuracy of many objects.

I calculated the monthly average of that accuracy for each object.
Then I classify the monthly average into high, middle, and low.

I want to create a pie chart that shows how many objects with average accuracy fit that classification.

I made an example via the attached excel.

Thank you!

[justISO]

Hi, not so elegant solution, but without additional loading of 'dummy' measures in load script, you can aggregate everything in report level like this:

as pie chart slice dimensions you create 3 values with expression

ValueList('High', 'Medium', 'Low')

as angle measure you assign count of Codes to dimension values. Expression:

pick(match(ValueList('High', 'Medium', 'Low'),'High', 'Medium', 'Low'),
count( if(aggr(nodistinct avg(Accuracy), Code)>=0.75, Code)),
count( if(aggr(nodistinct avg(Accuracy), Code)>=0.5 and aggr(nodistinct avg(Accuracy), Code)<0.75, Code)),
count( if(aggr(nodistinct avg(Accuracy), Code)<0.5, Code))
)