Multiply Values from each Series  Manufacturing Yield by Station
Hello!
I am trying to determine the overall yield of a manufacturing line. The data columns include the date, the station, which is a column of row labels representing each station in the manufacturing line, the number produced, and the number of defects.
I am able to find the yield by station, by creating a yield function in Beastmode (1  SUM(`Defect Quantity`) / SUM(`Production Quantity`)), then creating a graph with the station names along the x axis and the yield % along the y axis. However, I am trying to find the overall yield for the line, which requires multiplying together the yield of each station. I know its possible in an ETL, but I want the card to be responsive with other cards. E.g., When I select a time period in another card, I would want the overall yield to update as well.
Below is my attempt to create a Beastmode function, but the output is not correct. For example, if Station A has 3 defects out of 10, and station B has 2 defects out of ten, the overall yield of the line would be (.70)*(.80) = .56. However, this function would evaluate to (7+8)/(10+10) = 0.75. Any ideas of how to tackle this?
(CASE when `Station` = 'Station A' then 1  SUM(`Defect Quantity`) / SUM(`Production Quantity`) else 1 End ) * (CASE when `Station` = 'Station B' then 1  SUM(`Defect Quantity`) / SUM(`Production Quantity`) else 1 End )
Comments

In your sample scenario, it seems like the overall yield should be 75%, not 56%. I'm not clear as to why you would be multiplying the individual station yields together. If you thought of all the production as one station, you would have 7+8 and 10+10 which would give you 15/20 or 75%.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
 7.4K All Categories
 13 Getting Started in the Community
 150 Beastmode & Analytics
 1.8K Data Platform & Data Science
 54 Domo Everywhere
 2K Charting
 1K Ideas Exchange
 905 Connectors
 239 Workbench
 343 APIs
 77 Apps
 19 Governance & Productivity
 237 Use Cases & Best Practices
 50 News
 473 Onboarding
 573 日本支部