To envision my use case, here’s a couple of tags I have:
- machine ID
- “job type” ID
- speed float
Each “machine” has each of these tags.
“job type” and speed are currently being stored in tag history already. But I also want to do some transaction groups that store in a more columnar format so I can do something like
SELECT AVG(speed) FROM data GROUP BY job_type WHERE machine_id = xyz or something.
I realize that this is effectively duplicating the data in the tag history table(s) that ignition creates internally as well as now in a new table being written to by a Transaction Group.
Is this an acceptable way to go about it? Is there a better way that I’m overlooking?