Hello,
We have a table that we use to record scrap. Each scrap entry is a new table entry with the order # and scrap type listed. We would like to build an analysis that displays a pareto for types of scrap for the order that is currently running.
The issue: to do this we have found doing a pareto for the entire table and then filtering by ‘Order Number Equals = 15232’. There are a couple issues with this. First, we would need a new analysis for each order (thousands a month) because we cant reference a app variable in the filter. This solution just isn’t practical for our application.
Another possible solution could be to filter by machine, and then by time. 2 issues with this approach. 1. We have hundreds of machines, duplicating 4 analysis per machine X hundreds of machines is a huge issue
2. The time based filter is very problematic with the current functionality. If it is set as last hour it won’t reflect defects accurately over a 100 hr order, if its set to last 3 days that might include 5 different orders
This solution would only work if the time since was variable driven, based on order start time, but if we could do that, the original problem is resolved.
Thoughts?
Peter