# Designer Group and Transactions Data: How could I plot the current data per minute from any column from the POSTGRESQL database? **URL:** \ **Category:** Ignition\ **Tags:** vision\ **Created:** [September 28, 2026, 4:01pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221 "2026-09-28T16:01:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Jesus\_Paz\_Gonzalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesus_paz_gonzalez/32/38287_2.png) [@Jesus\_Paz\_Gonzalez](https://forum.inductiveautomation.com/u/Jesus_Paz_Gonzalez)\ **Post date:** [September 28, 2026, 4:01pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/1 "2026-09-28T16:01:49Z")
Greetings to all colleagues. I have the following problem. SITUATION: With 4 Boolean variables (true/false) I need to record every minute that each of these 4 machines has been active. For this, I created a new TRANSACTION GROUP with its start and stop conditions (this works perfectly, and I can see how their values increment every minute - Int4). Additionally, I correctly set up a connection to a PostgreSQL database (where I can also see that these same values are recorded and updated), along with the historical record. **Finally, the problem is that I need to display this on a graph (Easy Chart or Chart) where I can see that numerical increment (the last value of each column that is being saved in the PostgreSQL database): Despite having created queries in different ways, so far I haven't been able to achieve it** 😔 **. If any IGNITION specialist has a suggestion, I would be deeply grateful.** Best Regards!!! ![Historical Hourly Graphic Case4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/d/8d6f267ba8dbbdff7d4e151aef088f4463eb4489.png) ![Historical Hourly Graphic Case3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e31a952239c67f0ab913994fee1b83499de1f3e.png) ![Historical Hourly Graphic Case2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/6/260328d6aad9ee323d5ce183a628fb76c44fd05d.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 28, 2026, 4:08pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/2 "2026-09-28T16:08:40Z")
The simplest way to put data from a transaction group into a chart would be to add a 'DB Table Historian' connection on the gateway: > **[DB Table Historian Provider | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/ignition-modules/tag-historian/tag-history-providers/db-table-historian-provider)** > > The DB Table Historian Provider acts as a bridge between tables in a database connection and the Historian module, mapping columns in the tables as available tags, allowing historical tag queries to access the contents of the table. Usually... Then you would get a browse-able tag reference you can use in the Easy Chart/Power Chart/etc easily. ---
**Author:** ![Jesus\_Paz\_Gonzalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesus_paz_gonzalez/32/38287_2.png) [@Jesus\_Paz\_Gonzalez](https://forum.inductiveautomation.com/u/Jesus_Paz_Gonzalez)\ **Post date:** [September 28, 2026, 4:16pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/3 "2026-09-28T16:16:11Z")
Thank you very much, Engineer Paul-Griffith, I am going to try your recommendation and I will let you know if it works out for me. ---
**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:** [September 28, 2026, 4:23pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/4 "2026-09-28T16:23:08Z")
> [@paul-griffith](#): > > simplest way to put data from a transaction group into a chart _Cough_ **Vision**. The EasyChart component can directly handle your table with its **DB Pens** feature. The regular Chart component requires you to supply data in a binding--you can use named query bindings to supply the data. ---
**Author:** ![Jesus\_Paz\_Gonzalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesus_paz_gonzalez/32/38287_2.png) [@Jesus\_Paz\_Gonzalez](https://forum.inductiveautomation.com/u/Jesus_Paz_Gonzalez)\ **Post date:** [September 28, 2026, 4:32pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/5 "2026-09-28T16:32:44Z")
> [@pturmel](#): > > **DB Pens** feature Respectfully appreciated Engineer pturmel, I tried to use that DB Pens method. Unfortunately, I surely do not have the sufficient skills to do it, but it would be interesting to know how it can be properly configured. Notice: I can`t able to upload or share more photos because as a new user I was only allowed to upload 3 photos. ---
**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:** [September 28, 2026, 4:48pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/6 "2026-09-28T16:48:12Z")
Start with the docs here: > **[Vision - Easy Chart Customizer | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/components/vision-components/charts/easy-chart/easy-chart-customizer)** > > The Easy Chart component allows you to display the history of your Tags on a chart. When you drag and drop Tags onto an Easy Chart, it automatically trends the data for you. It has a special customizer that has some default settings to help you get... Note the "Database Pens" section in the middle of the customizer. Use the green plus sign on the right to create a pen. ---
**Author:** ![Jesus\_Paz\_Gonzalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesus_paz_gonzalez/32/38287_2.png) [@Jesus\_Paz\_Gonzalez](https://forum.inductiveautomation.com/u/Jesus_Paz_Gonzalez)\ **Post date:** [September 28, 2026, 4:49pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/7 "2026-09-28T16:49:01Z")
Hi Eng. Paul-Griffith, your recommendation was successful, I finally achieved the goal: I was able to see the precise ON-DUTY values (minute by minute) of the 4 machines graphically. I already had an SQL Historian created but it helped me to create the one you suggested: DB TABLE HISTORIAN!!! Thank you so Much...... ![Historical Hourly Graphic Case6](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/6/860622e32b75f9796b48ddf1f2f644e2089a3d21.png) ![Historical Hourly Graphic Case5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/c/0c6c506ec40db448d6ab2a68cf67c7b4c1a7052e.png) ---
**Author:** ![Jesus\_Paz\_Gonzalez](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jesus_paz_gonzalez/32/38287_2.png) [@Jesus\_Paz\_Gonzalez](https://forum.inductiveautomation.com/u/Jesus_Paz_Gonzalez)\ **Post date:** [September 28, 2026, 4:55pm UTC](https://forum.inductiveautomation.com/t/designer-group-and-transactions-data-how-could-i-plot-the-current-data-per-minute-from-any-column-from-the-postgresql-database/117221/8 "2026-09-28T16:55:16Z")
Thanks a lot, Engineer Pturmel... Yeah, I’ll also try using this method you suggested... I’m probably missing something during the setup or configuration.