Golden Batch Events/Trends

A common use of  historical data is that of a Golden Batch. This represents the best case for the manufacturing of a product. When there is an issue in a batch, the data collected during its manufacture is compared to the data from the golden batch.

I am working on an application where a client will enter both a Job Number and Product SKU at the beginning of a production run. These will be historiated as string values. I would like to be able to search for this run by entering the Job Number of Product SKU. The Job Number would be unique while the SKU would likely occur many times. It is possible the Job Number might would be used multiple times.

From a functionality standpoint, the tool would return a list of time periods that matched the Job Number/SKU. The user would then select the period of interest which would then be visualized against the Golden Batch. The tool would also need to be able to identify/change the Golden Batch.