I would like to be able to query one of our tags to get how many hours within a month that it is above X setpoint. It seems like I should be able to do this with the reporting module but I can't seem to figure out how to do so. I know this would be doable if I took an expression bool tag, historized it, and after a month took the Duration On calculation but I need the information sooner than that.
See the solution here, Create a report that shows how long a REAL value was above a setpoint each hour for the month - #5 by nminchin
While the post was for a report, you can run that script regardless.