cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Faadiz Frequent Visitor
Frequent Visitor

Production & Defects % Pareto from Column to Rows

HELP!
 
how can i convert below columns to ROWs?
 
tried unpivot but Production can only be 1 record per day. its also duplicating. also how to calculate % of each defect based on that specific date production?
 
i also need pareto of each defect.
 
defect % trend.
 
seems hard when i have records in columns.
 
this is just an example. actual data span over 30 columns with specific defects.
 
further details, there are 5 departments and each having 4-5 different defects. All in separate columns?
 
 

Capture.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Production & Defects % Pareto from Column to Rows

@Faadiz unpivot is the way to go, if you can share sample data wiht required result I can get you the solution.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




Community Support Team
Community Support Team

Re: Production & Defects % Pareto from Column to Rows

@Faadiz,

 


 
tried unpivot but Production can only be 1 record per day. its also duplicating. also how to calculate % of each defect based on that specific date production?
 
i also need pareto of each defect.
 
defect % trend.
 
seems hard when i have records in columns.
 
this is just an example. actual data span over 30 columns with specific defects.
 
further details, there are 5 departments and each having 4-5 different defects. All in separate columns?
 
 

Capture.PNG 


Yes, unpivot should work. In addtion, does the column DEF% is an exist column or just a custom column which should be added after unpivot operation? How about the "pareto "? Could you share the expected table structure?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Super User
Super User

Re: Production & Defects % Pareto from Column to Rows

@Faadiz unpivot is the way to go, if you can share sample data wiht required result I can get you the solution.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




Community Support Team
Community Support Team

Re: Production & Defects % Pareto from Column to Rows

@Faadiz,

 


 
tried unpivot but Production can only be 1 record per day. its also duplicating. also how to calculate % of each defect based on that specific date production?
 
i also need pareto of each defect.
 
defect % trend.
 
seems hard when i have records in columns.
 
this is just an example. actual data span over 30 columns with specific defects.
 
further details, there are 5 departments and each having 4-5 different defects. All in separate columns?
 
 

Capture.PNG 


Yes, unpivot should work. In addtion, does the column DEF% is an exist column or just a custom column which should be added after unpivot operation? How about the "pareto "? Could you share the expected table structure?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.