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.
Tes Sie on
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.