Total runtime of a line using SQL Historian DurationOn

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 (137.1 KB)

Solved

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