Production Routes Sunburst diagram

Copper Contributor

Hello,

 

I have a ton of data about our production over the last 2 years. The data is contains all the produciton jobs we ran over the past two years. For every job it shows its production route. My goal is to find out what the main production routes were over the past 2 years. I am thinking about showing the data in a sunburst diagram.

 

For example: 40% of the production starts in FlatLaser, 50% of what comes from LaserFlat goes to BendFlat as the second operations. Another 30% of what comes from LaserFlat goes to Grinding. And so forth...

 

I have tried many different ways, but I cannot quite figure out how to output my data to be able to correctly show it in a sunburst diagram. Can somebody please tell me how I can make this work? I have attached a file to show what the data looks like. 

 

Thanks in advance!

 

Julian

0 Replies