# Issues storing real arrays with transaction groups and plotting arrays with XY chart

**URL:** <https://forum.inductiveautomation.com/t/issues-storing-real-arrays-with-transaction-groups-and-plotting-arrays-with-xy-chart/70871>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [March 9, 2023, 9:08pm UTC](https://forum.inductiveautomation.com/t/issues-storing-real-arrays-with-transaction-groups-and-plotting-arrays-with-xy-chart/70871 "2023-03-09T21:08:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lance\_Mills](https://avatars.discourse-cdn.com/v4/letter/l/8edcca/32.png) [@Lance\_Mills](https://forum.inductiveautomation.com/u/Lance_Mills)\
**Post date:** [March 9, 2023, 9:08pm UTC](https://forum.inductiveautomation.com/t/issues-storing-real-arrays-with-transaction-groups-and-plotting-arrays-with-xy-chart/70871/1 "2023-03-09T21:08:44Z")

</div>

Hi there,

I would like to historize some arrays every time a sequence is executed and then plot the latest array values to an XY Chart.

The 2 issues I have are:  
1.) I'm not able to store real arrays to a database using the transaction groups.  
2.) I'm not sure how to plot arrays to an XY chart.

**Issue 1**  
It's showing that there are writes to the database, but I'm seeing no values in the table when I do a query (SELECT \* FROM table).

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/e/ce6795f1d9002b6f66eaf3acaf6563884d8a0118.png)

I have repeated this test with single floats that continuously change and with the same trigger and I was able to see data stored to the database. However as shown from the query below any changes to a real array doesn't store any data to the database.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/3/33e34e24e2acde96e695c3900469e0e837281f83.png)

**Issue 2**  
So the main goal is plot the arrays to an XY chart when a page is loaded or when a t\_stamp index is selected from a dropdown. As shown below, I'm planning to do a query of the top row of the database and then map the dataset to a local tag to use for plotting in the XY chart. Would this be the best way to plot arrays or is there simpler alternative?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/a/8ad89a7a5b5ba3b925c07a7d9eda4a4e7018083c.png)

Any help would be appreciated with either issue.

Thanks,  
Lance
