I would like to use Batchview in Pi Process book to display past batch times to operators.
How would I add control limits to display in Batch view Gant chart when a batch time is over the expected batch time for that specific product.
I have the "desired" batch times in a spreadsheet correlated to product name. Product name for each batch is already pulled to batch view.
Is there a way to reference/vlookup in a spreadsheet or create a table in Pi so batch view knows what expected batch time should be for each product to display control limits/conditional formatting?