# Create a table showing value hour by hour in Reporting module

**URL:** <https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868>\
**Category:** Ignition\
**Tags:** reporting\
**Created:** [February 10, 2026, 12:56pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868 "2026-02-10T12:56:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![neighbour.drilling](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@neighbour.drilling](https://forum.inductiveautomation.com/u/neighbour.drilling)\
**Post date:** [February 10, 2026, 12:56pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/1 "2026-02-10T12:56:17Z")

</div>

Hi, I’m trying to create a table showing the last 24 values polled every hour from several historic tags. However, in the designer the data source only seems to hold onto one value making it impossible to create a table with. I might be wildly misunderstanding how the tag historian query works.

I saw some threads talk about the “LastValue” Aggregation mode but i’m on 8.3 and don’t have that option.

Any suggestions appreciated!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/76d799f1f2ce3ef62e28966ea9a48870f27ed846.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 10, 2026, 2:52pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/2 "2026-02-10T14:52:43Z")

</div>

Set your interval to 24 Hour.

Make sure your start date has zero minutes, seconds, and milliseconds. Make sure your end date is 24 hours after the start date, less one millisecond.

---

<div class="post-metadata">

**Author:** ![neighbour.drilling](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@neighbour.drilling](https://forum.inductiveautomation.com/u/neighbour.drilling)\
**Post date:** [February 11, 2026, 1:00pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/3 "2026-02-11T13:00:59Z")

</div>

Hi, thanks for your comment.  
Somehow I still get only one value not a set of 24.

Based on this[](https://www.docs.inductiveautomation.com/docs/8.3/ignition-modules/vision/binding-types-in-vision/tag-history-bindings-in-vision) [Tag History Bindings in Vision | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/ignition-modules/vision/binding-types-in-vision/tag-history-bindings-in-vision) [i](https://www.docs.inductiveautomation.com/docs/8.3/ignition-modules/vision/binding-types-in-vision/tag-history-bindings-in-vision)t seems to me that Interval should indeed be set to 1 hour.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [February 11, 2026, 1:04pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/4 "2026-02-11T13:04:22Z")

</div>

7.8 is mega old. Many many changes since 7.8 and 8.3. Go for the 8.3 documentation and work off that.

---

<div class="post-metadata">

**Author:** ![neighbour.drilling](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@neighbour.drilling](https://forum.inductiveautomation.com/u/neighbour.drilling)\
**Post date:** [February 11, 2026, 1:12pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/5 "2026-02-11T13:12:54Z")

</div>

Thanks, i updated the reference to the 8.3 manual which says the same thing.

---

<div class="post-metadata">

**Author:** ![neighbour.drilling](https://avatars.discourse-cdn.com/v4/letter/n/848f3c/32.png) [@neighbour.drilling](https://forum.inductiveautomation.com/u/neighbour.drilling)\
**Post date:** [February 12, 2026, 12:20pm UTC](https://forum.inductiveautomation.com/t/create-a-table-showing-value-hour-by-hour-in-reporting-module/113868/6 "2026-02-12T12:20:40Z")

</div>

I ended up using scripting for the data source. There’s something off with the tag historian query.