I want to calculate the SCRAP RATE of different Lines and the overall average scrap rate over all lines together (see dashboard).
For the calculation of the scrap rate over all lines it is just summing up the percentages form the further calculated percentages of the lines and not giving a new average over all lines !
What I want is the average of failing parts over lines (scrap on line x / output line x) for each station and the overall scrap rate over all lines (scrap all lines / total output)
Thanks for support
Do the below numbers look correct to you now? For verification purposes, I have included the Scrap Count and Quantity too.
The issue was that the data was not blended correctly.
The workbook is attached. Hope this helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...