Forum Discussion

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago

Create Pie chart with group by

Hi all,   I have a dataset like this:   emp nr  year_month uniquenumber 161860 201702         25005 161860 201702         25006  161860 201703         25007  365630 201702         25008  365...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi MiKeZZa，

For pie visual, you select the "numberofcategories" field as Legend level, and Percent measure as value level?

 

Best Regards,
Angelia

MiKeZZa's avatar
MiKeZZa
Icon for Post Patron rankPost Patron
9 years ago

No, still not good unfortionately....

 

If I select 1 person I have this dataset:

 

emp nr  year_month numberoftimestocount costcentre

161860 201606         0                                    1234

161860 201607         0                                    1234

161860 201608         0                                    1234

161860 201609         0                                    1234

161860 201610         0                                    1234

161860 201611         0                                    1234

161860 201612         0                                    1234

161860 201701         1                                    1234

161860 201702         0                                    1234
161860 201703         0                                    1234

 

This must result in 1 person that has 1 as count. So it must be a piechart with 100% score for group '1'. But what I get is this:

 

So it looks like he splits the data on the number of incidents, instead of summing them....

 

Can somebody PLEASE help me?