Hi! I am looking for Ideas. I have the historian logging some process event information and what I want to do now is to see if I can divide the information by shifts, for example, I would like to have a historian query that returns the “Count On” of the events that happened on Monday and Wednesday between 6:00am and 6:00pm. My plan B is add a transaction group and start logging the information that way but since I already have the information on the historian I would like to use it if possible to avoid duplicating records.
Any ideas on how to solve this? I was thinking on adding a custom aggregate but at the time I am not able to get it to work, I’ve tried implementing the example with the myCount function (link: https://docs.inductiveautomation.com/display/DOC79/Custom+Tag+History+Aggregates) but it just returns the data on my table, nothing that resembles a counter.
Any help will be appreciated.