# Total runtime of a line using SQL Historian DurationOn

**URL:** <https://forum.inductiveautomation.com/t/total-runtime-of-a-line-using-sql-historian-durationon/37827>\
**Category:** Ignition\
**Created:** [August 17, 2020, 9:03pm UTC](https://forum.inductiveautomation.com/t/total-runtime-of-a-line-using-sql-historian-durationon/37827 "2020-08-17T21:03:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![james3](https://avatars.discourse-cdn.com/v4/letter/j/b5e925/32.png) [@james3](https://forum.inductiveautomation.com/u/james3)\
**Post date:** [August 17, 2020, 9:03pm UTC](https://forum.inductiveautomation.com/t/total-runtime-of-a-line-using-sql-historian-durationon/37827/1 "2020-08-17T21:03:30Z")

</div>

Hi, I am using Ignition 7.9.2 and am trying to calculate total runtime for a line that has two beater bars. I need total runtime, runtime is when either beater bar is running. I am trying to show this on a report. I have attached a PDF and you’ll see that my graphs each show the 2 beater bars and their time on. Then the total runtime is above them, but is not correct. I am still new to ignition and currently doing the free stuff online. I could not find anything on the forums that is like what I am trying to do. I currently have a transaction group to make my table and then use that for the report data for the graphs. Any help will be appreciated. Thank you

[FarmWagonUpTime 8-17-20 12PM.pdf](https://forum.inductiveautomation.com/uploads/short-url/ri1XCZ0dGNKBf9CpfJmvZIFWkXh.pdf) (137.1 KB)

---

<div class="post-metadata">

**Author:** ![james3](https://avatars.discourse-cdn.com/v4/letter/j/b5e925/32.png) [@james3](https://forum.inductiveautomation.com/u/james3)\
**Post date:** [October 22, 2020, 3:19pm UTC](https://forum.inductiveautomation.com/t/total-runtime-of-a-line-using-sql-historian-durationon/37827/2 "2020-10-22T15:19:13Z")

</div>

Solved

---

<div class="post-metadata">

**Author:** ![jantonevich](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jantonevich](https://forum.inductiveautomation.com/u/jantonevich)\
**Post date:** [March 16, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/total-runtime-of-a-line-using-sql-historian-durationon/37827/3 "2023-03-16T14:09:44Z")

</div>

Could you supply how you solved it for others looking for the same functionality?