# Tag History Hours Above X Setpoint

**URL:** <https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [December 2, 2022, 11:19pm UTC](https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199 "2022-12-02T23:19:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![markusx1094](https://avatars.discourse-cdn.com/v4/letter/m/77aa72/32.png) [@markusx1094](https://forum.inductiveautomation.com/u/markusx1094)\
**Post date:** [December 2, 2022, 11:19pm UTC](https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199/1 "2022-12-02T23:19:02Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [December 3, 2022, 12:49am UTC](https://forum.inductiveautomation.com/t/tag-history-hours-above-x-setpoint/67199/2 "2022-12-03T00:49:01Z")

</div>

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](https://forum.inductiveautomation.com/t/create-a-report-that-shows-how-long-a-real-value-was-above-a-setpoint-each-hour-for-the-month/58897/5)

While the post was for a report, you can run that script regardless.
