# Ignition Weekly Totalizer Reporting

**URL:** <https://forum.inductiveautomation.com/t/ignition-weekly-totalizer-reporting/55842>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [February 8, 2022, 1:14am UTC](https://forum.inductiveautomation.com/t/ignition-weekly-totalizer-reporting/55842 "2022-02-08T01:14:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![John\_Smith](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@John\_Smith](https://forum.inductiveautomation.com/u/John_Smith)\
**Post date:** [February 8, 2022, 1:14am UTC](https://forum.inductiveautomation.com/t/ignition-weekly-totalizer-reporting/55842/1 "2022-02-08T01:14:06Z")

</div>

I’d appreciate anyone to point me in the right direction.

I am using Ignition 8.1. I have configured a flow totalizer tag that is logging to the tag historian (MSSQL) upon every change. I want to create a weekly report, i.e. 7 columns (Mon-Sun), that displays the;  
a. Starting (min) volume and  
b. Ending (max) volume and finally  
c. Total volume (b-a) volume of that day.

As I’m new to Ignition reporting, I assume I should be using the “Tag Historian Query” as query type instead of the SQL Query as I would have to query multiple history tables (currently partitioned per month).

Any assistance on how I can achieve the above would be appreciated.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [February 8, 2022, 1:36am UTC](https://forum.inductiveautomation.com/t/ignition-weekly-totalizer-reporting/55842/2 "2022-02-08T01:36:53Z")

</div>

You have some options, You could use a tag historian query, in addition to a script query to massage your data into a format you can use. You could also create a gateway scheduled script to record the data on a daily basis to a table of your own creation, then you can use a regular sql query for your report data source. I chose the latter approach to record total power usage from electrical meters.

---

<div class="post-metadata">

**Author:** ![John\_Smith](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@John\_Smith](https://forum.inductiveautomation.com/u/John_Smith)\
**Post date:** [February 8, 2022, 8:37pm UTC](https://forum.inductiveautomation.com/t/ignition-weekly-totalizer-reporting/55842/3 "2022-02-08T20:37:31Z")

</div>

I like a simple solution, thanks @josborn