Hello,
What is the best way to keep records of rectangular boards on a production line with a Length,width and batch Number for each one ?
The purpose is to do some statistics like "There were 241.458 Boards of 4feet long and between 2 and 5 inches wide in the 2 past weeks" (using PI DataLink, PI vision, Event frames or some other utility)
related post : Linked value/attributes for each piece
Regards,
Are the records ad hoc or a system of record?
If they are ad hoc, I would use DataLink and an OLEDB query to get the data; you can have the user enter the parameters as needed.
If the data is needed as a historical record, then parameters need to be pre-determined:
length (min/max) (4 feet to 5 feet) or fixed length
width (as above)
time range (x production days with a defined production day start) or weekday to weekday such as Sunday at 7:00 AM to Sunday at 6:59 AM
Then, with parameters defined, you can create rollups in AF and event frames; that will maintain the data over time.