PD

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.

 

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.

0
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

0
by Prakash Desai Author
Posted on Wed, 11/09/2011 - 16:40

Thank you guys for help. It did work and i got what i needed. Once again, thank you.

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock