Historian help needed

[zacharyw.larson]

thanks

Simulation Aids is on my local.
The datasets I need to work on are on production, and I am not authorized to add modules to the gateway or add resources from exchange to the project.

---

I didn't know Partition By was a thing in queries.
I also need to read up on lead and lag.

Calculating Total Time in Seconds

I usually do all of this in the database with lead() and/or lag() window functions. Say you have multiple of these recording to a single table, using an id column to segregate them. You record every change, and due to tag restarts or script restarts you get some duplicate rows as you’ve shown. The query to pick out all of the completed cycles that overlap a time period would be something like this: Select id, t_stamp, finish_ts, finish_ts - t_stamp As duration From ( Select id, t_st…

This thread was linked early in this thread, and I like your post on it.
I think I need to implement that kind of query.

---

I don't think a tag historian binding has "partition by" functionality.
I think for this fault code , I have to use the transaction group since I can't add the resource that you made.