We are collecting pump on/off statuses as historical tags and we want to run a daily pump summary report on this information. The raw dataset looks like the attached below.
And the outputs we are looking to calculate for a day are:
Count turned on
Total pump runtime
Longest time run
Shortest time run
Does the reporting module have any built in keys that can summarize the raw data for us? Or would we be better served writing a custom query for this data?