# Reporting Module - Calculating Pump Runtimes

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-calculating-pump-runtimes/6010>\
**Category:** Ignition\
**Created:** [March 11, 2013, 4:08pm UTC](https://forum.inductiveautomation.com/t/reporting-module-calculating-pump-runtimes/6010 "2013-03-11T16:08:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nate.Olson](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nate.Olson](https://forum.inductiveautomation.com/u/Nate.Olson)\
**Post date:** [March 11, 2013, 4:08pm UTC](https://forum.inductiveautomation.com/t/reporting-module-calculating-pump-runtimes/6010/1 "2013-03-11T16:08:19Z")

</div>

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?

Thanks  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4f51b4c09971b137e7b78fe49074372f48f1ce6f.jpg)

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [March 14, 2013, 6:39pm UTC](https://forum.inductiveautomation.com/t/reporting-module-calculating-pump-runtimes/6010/2 "2013-03-14T18:39:59Z")

</div>

The report module does provide count, total, min and max functions for numeric data. Turned on count will work fine, but trying to analyze the time stamps to derive longest / shortest / total time interval is not currently supported, so you will have to take the writing the query route.