Pie chart help

Posted by Prakash Desai

Posted on Mon, 10/31/2011 - 19:22 in MashZone

Hi MashZone Team

I have follwoing table structure in excel spreadsheet.

Name laborcategory projectname hours deptname

----------------------------------------------

john fulltime project1 8 dept1

john fulltime project2 10 dept1

Mark contractor project1 8 dept1

Mark contractor project2 10 dept1

Paul fulltime project1 8 dept1

Paul fulltime project2 10 dept1

I have been working on different charts on this data but there is one need where i need to show %contractor vs % fulltime for deptment in PieChart. For this example , it would be

2 full time and 3 contracts in dept 1 (66% FTE vs 33% Contractor). How do i do it?

Please help.

Thanks.

23.6k

by Tes Sie

Posted on Wed, 11/09/2011 - 05:15

Hi Prakash,

You could add an aggregation and use laborcategory as the dimension column, hours as the aggregation column and count as the aggregation type. This should give you the output your after.

Hope this helps.

by Stephan Freudl

Posted on Wed, 11/09/2011 - 08:49

Hi,

exactly as Prakash indicated. Distinct values of column laborcategory generate the number and name of segments, any numeric column provides their angles.

Further info might be given by this video.

Regards

Stephan