What this is
When a part or unit has an issue, operators sometimes open a Failure Form instead of marking the item as rejected.
Managers often want to see:
How many units had a failure form?
Which work orders or batches were affected?
Where in the process did it happen?
This guide shows you how to connect Work Orders with Failure Forms so you can answer those questions in dashboards.
How to do it
Start with Work Orders
Create a new question in your dashboard.
Add Work Order Number, Status, and Quantity.
This gives you the list of orders to analyze.
Add Production Units (Stock)
Connect Work Orders โ Sessions โ Units (Stock).
Each serial or batch number will now appear under its work order.
Link the Failure Forms
Add the Failure Forms table.
Use an Inner Join on Stock ID.
Why Inner Join? Because you only want to see units that have a failure form.
This removes โnoiseโ from units without issues, so your report is focused.
Filter Closed Work Orders
Add a filter: Status = Closed.
This way you analyze only completed jobs.
Count Failures
Add a column that counts the forms.
Decide what you want to measure:
Number of Forms โ how many reports were filled.
Unique Units with Failures โ how many products were actually affected.
Visualize the Data
Show it as a table grouped by Work Order.
Or use a bar chart to compare failures across orders, stations, or dates.
Common Issues / FAQs
I see duplicates in the results
โ Sometimes more than one failure form is opened for the same unit. If you want to count only the unit once, use Unique Count.I want to compare good vs. bad units
โ In that case, use a Left Join instead of Inner Join. That way youโll also see units without forms, and you can filter by โHas Form = Yes/Noโ.Can I see failures by station?
โ Yes. Add Work Station to your view. This shows at which station the forms were opened.