# Tag history totalizer display using tables

**URL:** <https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140>\
**Category:** Ignition\
**Created:** [April 2, 2013, 8:09pm UTC](https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140 "2013-04-02T20:09:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fadihindi](https://avatars.discourse-cdn.com/v4/letter/f/34f0e0/32.png) [@fadihindi](https://forum.inductiveautomation.com/u/fadihindi)\
**Post date:** [April 2, 2013, 8:09pm UTC](https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140/1 "2013-04-02T20:09:06Z")

</div>

Is there a way to use the tag history binding on a table data property to display hourly or daily totals of tags without using a custom query? I can display hourly/daily averages, min/max, etc, but I would like to display hourly/daily totals (essentially for flows) for production reports. If not what would be the simplest way to query the tag history to produce such tables? I would like to show hourly, daily, and monthly totals if possible (using separate tables), but can limit to hourly and daily only if more practical.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 2, 2013, 8:32pm UTC](https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140/2 "2013-04-02T20:32:15Z")

</div>

Right now you cannot do hourly or daily totals in the binding. In this case you can bring back the natural data to a table and perform sum calculations through expression bindings. So if you had a table with all of the data in it for a given time period you can create an expression like this:`sum({Root Container.Table.data}, "MyTagCol")`in a separate component. You can allow the user to change the time period from one hour to one day or more.

---

<div class="post-metadata">

**Author:** ![tailfire](https://avatars.discourse-cdn.com/v4/letter/t/b5a626/32.png) [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\
**Post date:** [April 3, 2013, 1:56am UTC](https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140/3 "2013-04-03T01:56:46Z")

</div>

This postsounds VERY FAMILIAR… I have been doing some research. Sounds like you and I are looking for a similar function. What I have identified is the ‘area under the curve’ which would be using Reimann Sum.  
There are some examples that you might google. I have been looking at:  
[reedr95.github.com/code/2012/11/ … ython.html](http://reedr95.github.com/code/2012/11/26/Visualizing-Riemann-Sums-with-Python.html)

I think this would be something that can actually be accomplished with Ignition. I was also given advice that i could inquire about design hours also. I am not against the design hours I just cannot justify a purchase order for it at my company, so I am going to have to beat on the brick wall awhile and find some sort of comparable solution.

If you find a solution before I do please re-post. I will do the same.

---

<div class="post-metadata">

**Author:** ![shibubalaji](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/shibubalaji/32/9165_2.png) [@shibubalaji](https://forum.inductiveautomation.com/u/shibubalaji)\
**Post date:** [December 9, 2018, 5:15pm UTC](https://forum.inductiveautomation.com/t/tag-history-totalizer-display-using-tables/6140/4 "2018-12-09T17:15:11Z")

</div>

Travis, You are awesome man… I was just looking for this table sum fucntion. great…
