Collecting Data and Aggregation Tag Historian vs Transaction Group


I am trying to track the temperature of carrier as long as the carrier stays on the particular station. I would like to get the Average, Maximum and Minimum temperature during that period and write those values into separate table.

I am exploring both Tag Historian and Transaction Group for this purpose.

What would be the best way to do this.

In my experience, when you need to collect values that will be correlated with each other, the tag historian is terrible. I would use a transaction group that records at a steady pace while a carrier is present in the station, capturing the carrier ID or product serial, and temperature, and any other process variable that might turn out to be useful for analytics.

Then your reporting can use standard SQL GROUP BY on the carrier ID or serial number to perform your analytics. Doing the same thing with the historian is a horrible mess of scripting.