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%.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有