Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post 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
MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Out of the box is even better.... :)

 

Both answers are not exactly what I'm looking for. To be more clear some extra data:

 

emp nr  year_month uniquenumber
161860 201702         25005
161860 201702         25006 
161860 201703         25007 
365630 201702         25008 
365630 201703         25009 

365631 201702         25010 
365631 201703         25011 

365632 201702         25012 
365632 201703         25013 

 

1 part with 3 (for emp nr 161860)

3 part's with 2 (for emp nr 365630, 365631 and 365632).

 

So I want 2 parts; 1 with 25% and value 3 and 1 with 75% and value 2. Tomorrow I'll check the link; maybe that explains everything...

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

I have tried it with the blog but I don't think it's what I need. I don't want to make my own groups, but I want to group on the outcome of the calculation. So it must become something like this: