# Hourly Chart with Single Tag

**URL:** <https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434>\
**Category:** Ignition\
**Created:** [June 5, 2024, 6:06pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434 "2024-06-05T18:06:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stephanie\_Aguiar](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@Stephanie\_Aguiar](https://forum.inductiveautomation.com/u/Stephanie_Aguiar)\
**Post date:** [June 5, 2024, 6:06pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/1 "2024-06-05T18:06:52Z")

</div>

I need some support with this. I have a hourly chart I would like scripted. I want so that it has live data within its time frames but once that time frame is done it remains in the last value of that time frame. I have a single tag that will be the one giving the values(the highlighted tag). any advice would help!

 ![Screenshot 2024-06-05 110155](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/8/58f987f763c896f5182ddc8195d6f7f311cc4b3a.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 5, 2024, 6:12pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/2 "2024-06-05T18:12:14Z")

</div>

I recommend that you record the count every hour and save it in a database.  
You asked for a "chart", but I think you mean a "table" and the table component with a database binding would be very simple and tidy.

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [June 5, 2024, 7:33pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/3 "2024-06-05T19:33:15Z")

</div>

Another option for this would be to create a Dataset tag with each of the time frames that you want to store, and then on the hour trigger record the tag value into that. Then a simple tag binding to a table, or some other form of mapping can be used to display the data.

This will work so long as you don't care to abandon the data after 24 hours.

---

<div class="post-metadata">

**Author:** ![Stephanie\_Aguiar](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@Stephanie\_Aguiar](https://forum.inductiveautomation.com/u/Stephanie_Aguiar)\
**Post date:** [June 5, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/4 "2024-06-05T20:00:22Z")

</div>

thats actually what I have right now, but I wanted it show it incrementing live while its on each time frame

---

<div class="post-metadata">

**Author:** ![Stephanie\_Aguiar](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@Stephanie\_Aguiar](https://forum.inductiveautomation.com/u/Stephanie_Aguiar)\
**Post date:** [June 6, 2024, 3:06pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/5 "2024-06-06T15:06:14Z")

</div>

Hi, I thought of this but I didn't go with this solution because like I mentioned I want the live data when it is going thru the current time frame. Unless I am wrong and what you said is capable of doing that

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 6, 2024, 3:13pm UTC](https://forum.inductiveautomation.com/t/hourly-chart-with-single-tag/91434/6 "2024-06-06T15:13:20Z")

</div>

![Query tag polling](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/e/be0cd1fc8a76936f348b81e97ebe8add6b4105d1.png)

You would create a named query - usually with some search criteria parameters - and then use that in a Query Binding.

I think you're using Vision (add the tag from the dropdown below your question title) and I do little work in that so it may be different to how this would be done in Perspective.
