I have a discrete points (each being its own PI tag) which represents types of trips our furnaces encounter. I'm looking for ideas on how to totalize this type of data so I can quantify how many trips we have in a certain time frame, which furnace has the most, which electrode within a furnace has the most, etc. I am not having any success using the PI Builder/DataLinks tool in excel for this.

Appreciate any input.

Hello Derick,

Your case begs for using PI Calculated Data function in PI Datalink to get only the accumlated results:

How many times a furnace switched to phase 'TripLow' or how much time it was there all together in the given interval?

Try to use PI Calculated Data function with calculation mode count (event-weighted or time-weighted as it suites the best), and a filter expression, like: 'tagname'="TripLow" and Prevval('Tagname')<>"TripLow"

Best Regards,

Janos