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
 10.5K All Categories
 8 Connect
 918 Connectors
 250 Workbench
 469 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 477 Datasets
 193 Visualize
 252 Beast Mode
 2.1K Charting
 11 Variables
 17 Automate
 354 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 247 Distribute
 63 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 174 Product Ideas
 1.2K Ideas Exchange
 12 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive