# Transaction Group Data in Perspective Chart **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [January 25, 2021, 4:52am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566 "2021-01-25T04:52:07Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 25, 2021, 4:52am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/1 "2021-01-25T04:52:07Z")
Hello All, Just a quick question: is there an easy way to trend transaction group data (regular time series data) in perspective? I mean something like the easy chart for vision. Thanks, Neill ---
**Author:** ![0sm0](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/0sm0/32/15228_2.png) [@0sm0](https://forum.inductiveautomation.com/u/0sm0)\ **Post date:** [January 25, 2021, 5:43am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/2 "2021-01-25T05:43:27Z")
V8.1 has the Perspective Power Chart Just Setup a History Tag Provider using ‘DB Table Historian’ type and point it to your DB with the tables created by the Transaction groups. Have a play… ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 25, 2021, 8:11pm UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/3 "2021-01-25T20:11:54Z")
Thanks I managed to get my data into power chart tag browser. However, charting a tag doesn’t seem to work. Data is definitely in my database table. Additionally, the [timestampColumnName] is not automatically being defined despite the table using the default t\_stamp column. I’ll look into this further, hopefully this isn’t a bug. ---
**Author:** ![jball](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jball/32/11128_2.png) [@jball](https://forum.inductiveautomation.com/u/jball)\ **Post date:** [January 27, 2021, 12:56am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/4 "2021-01-27T00:56:27Z")
One thing to check… Make sure that the `t_stamp` column is the first column returned from your query. That order is important for the chart to accurately display data. ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 27, 2021, 1:05am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/5 "2021-01-27T01:05:16Z")
Thanks for the message. How do you change that? I am using MySQL. Below is a screen shot of my power chart: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f11e67d32c2a5b62f0c99c339edb80e0ccceead6.png) ---
**Author:** ![jball](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jball/32/11128_2.png) [@jball](https://forum.inductiveautomation.com/u/jball)\ **Post date:** [January 27, 2021, 1:25am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/6 "2021-01-27T01:25:51Z")
It would be in the query you have setup to build the table in MySQL that you’re using to create your DB historian. ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 27, 2021, 2:19am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/7 "2021-01-27T02:19:12Z")
I used a transaction group to make my table initially so you’d hope it set the table up properly to work within Ignition itself. The power chart is still not working when I manually make the table in the workbench with just a t\_stamp and index column, then adding a data column with a transaction group. Power Chart GUI: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/159659e24b46e1c7d584872ebef2045e9a93f976.png) My database table: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/29e45dcb0048540e65c136616bead3b3cf3391e9.png) What format must the t\_stamp be? I am currently using the inbuilt DateTime datatype. Thoughts? ---
**Author:** ![jball](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jball/32/11128_2.png) [@jball](https://forum.inductiveautomation.com/u/jball)\ **Post date:** [January 27, 2021, 5:06pm UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/8 "2021-01-27T17:06:57Z")
That certainly looks correct. I’d take a peek at the gateway logs and also the browser console and see if anything jumps out at you. If there’s nothing obvious in the logs/console, you can DM me a data export of the above image and I can try it out on my side. ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 28, 2021, 1:58am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/9 "2021-01-28T01:58:23Z")
I have just finished a support call and I was directed to use a timeseries chart with named queries. The following video clearly show what I am trying to archive: [https://www.inductiveuniversity.com/videos/db-table-historian/8.1/8.1](https://www.inductiveuniversity.com/videos/db-table-historian/8.1/8.1) Maybe this is a bug? ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 28, 2021, 2:00am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/10 "2021-01-28T02:00:40Z")
Apparently started fine: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d6b0000f2ddaef3f251e0a5c861e8875c5b9a05.png) State is unknown for some reason: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/d/0d3b9c9f3106ecfbbcd09e3e8b74d6bc16881820.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/9/a98ae3763403411c16915bb6c1378caea5591f87.png) ---
**Author:** ![neill](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@neill](https://forum.inductiveautomation.com/u/neill)\ **Post date:** [January 28, 2021, 3:45am UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/11 "2021-01-28T03:45:03Z")
I got to the bottom of this. You cannot use the perspective power chart without the tag historian module. Maybe it should be renamed to: “tag historian power chart”. ---
**Author:** ![jball](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jball/32/11128_2.png) [@jball](https://forum.inductiveautomation.com/u/jball)\ **Post date:** [January 28, 2021, 5:31pm UTC](https://forum.inductiveautomation.com/t/transaction-group-data-in-perspective-chart/42566/12 "2021-01-28T17:31:22Z")
Yes, that is certainly a prerequisite to using that component. All queries for data are done via the tag historian. If that dependency isn’t listed on the docs site, I will forward along a request to add it. Edit: Just checked; we’re good to go on the docs site.