# Create graph for each hour

**URL:** <https://forum.inductiveautomation.com/t/create-graph-for-each-hour/32378>\
**Category:** Ignition\
**Created:** [February 18, 2020, 3:15pm UTC](https://forum.inductiveautomation.com/t/create-graph-for-each-hour/32378 "2020-02-18T15:15:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [February 18, 2020, 3:15pm UTC](https://forum.inductiveautomation.com/t/create-graph-for-each-hour/32378/1 "2020-02-18T15:15:12Z")

</div>

hello everyone i’m using the graph and i want to graph every hour the production that the manufacturing takes

I already have the variabre where I take the count

I’m really new to this, I just want to give me a hint of how I can do it.

 ![Captura1](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2db02997ba411305c1b46625a91715a9dab83623.png)

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [February 18, 2020, 3:54pm UTC](https://forum.inductiveautomation.com/t/create-graph-for-each-hour/32378/2 "2020-02-18T15:54:59Z")

</div>

You can accomplish this a few ways. Typically you’d store tag history using either the [Tag Historian Module](https://docs.inductiveautomation.com/display/DOC80/Tag+Historian+Module) or the [SQL Bridge Module](https://docs.inductiveautomation.com/display/DOC80/SQL+Bridge+Module) (these require a license, but are the easiest to setup). For smaller amounts of data over a short term like this, you could also use a [gateway event tag change script](https://docs.inductiveautomation.com/display/DOC80/Gateway+Event+Scripts) triggered each hour to store the values in a dataset tag (and remove old values). See [system.dataset](https://docs.inductiveautomation.com/display/DOC80/system.dataset) functions. This is pretty easy if you understand Python scripting, but there’s a bit of a learning curve if you don’t. You’ll find more posts in this forum regarding editing datasets with scripting.

The way you’ve started doing this with a cell update binding will work if you have each of the historical values stored in a tag, but is probably not the ideal method.

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [May 7, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/create-graph-for-each-hour/32378/3 "2020-05-07T21:02:16Z")

</div>

you know if there is an example to guide use SQL as a database and mitsubishi PLC