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
 11.3K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.2K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.3K Connectors
 354 Workbench
 271 Domo Best Practices
 14 Domo Certification
 483 Domo Developer
 58 Domo Everywhere
 113 Apps
 734 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 305 仲間に相談
 667 ひらめき共有