# Short term (real-time) trending?

**URL:** <https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846>\
**Category:** Ignition\
**Created:** [April 15, 2024, 6:59pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846 "2024-04-15T18:59:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Harrison\_Ting](https://avatars.discourse-cdn.com/v4/letter/h/48db29/32.png) [@Harrison\_Ting](https://forum.inductiveautomation.com/u/Harrison_Ting)\
**Post date:** [April 15, 2024, 6:59pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846/1 "2024-04-15T18:59:53Z")

</div>

Is there such thing as short term trending in Ignition? We are using PI as our standard process historian so Ignition is only used as HMI but it would be nice to have small trends along side values to provide context for the operators. Beside, I don't think we bought the historian module.

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [April 15, 2024, 7:07pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846/2 "2024-04-15T19:07:31Z")

</div>

You can set up a transaction group to write specific values to a DB table on a 1 second interval, and then poll that table for short term data. You can set up your transaction group to delete records older than a set age if you don't need to keep the data for any long term trending. Transaction groups do require the SQL bridge module.

If you don't have the SQL Bridge module you can still script the equivalent of a transaction group in a gateway tag change event. You can include the dropping older records from this scripted transaction or let your database server handle it natively on the table you create.

---

<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:** [April 15, 2024, 7:09pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846/3 "2024-04-15T19:09:20Z")

</div>

I have a `recorder()` expression function in my Integration Toolkit module that will do short-term in-memory trends. You cannot use the Perspective PowerChart nor Vision EasyChart, though, as those charts do not accept custom datasets.

---

<div class="post-metadata">

**Author:** ![Harrison\_Ting](https://avatars.discourse-cdn.com/v4/letter/h/48db29/32.png) [@Harrison\_Ting](https://forum.inductiveautomation.com/u/Harrison_Ting)\
**Post date:** [May 6, 2024, 4:00pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846/4 "2024-05-06T16:00:21Z")

</div>

Hi pturmel, can you elaborate a bit on how to do this? Is this "Integration Toolkit" something we have access to and what kind of chart do you use?

---

<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:** [May 6, 2024, 4:54pm UTC](https://forum.inductiveautomation.com/t/short-term-real-time-trending/88846/5 "2024-05-06T16:54:29Z")

</div>

My Integration Toolkit module is an add-on module for Ignition that injects a bunch of useful expression functions and scripting functions. It does not provide any new components.

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934):
>
> Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

~~(Note, not available in Edge.)~~

The docs for the `recorder()` function are here:

[https://www.automation-pros.com/toolkit/doc/datasets.html#recorder](https://www.automation-pros.com/toolkit/doc/datasets.html#recorder)

Edit: Now available in Edge when buying either of my Edge-compatible drivers.
