Transaction Group Data in Perspective Chart

neill · January 25, 2021, 4:52am

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

0sm0 · January 25, 2021, 5:43am

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…

neill · January 25, 2021, 8:11pm

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.

jball · January 27, 2021, 12:56am

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.

neill · January 27, 2021, 1:05am

Thanks for the message.
How do you change that?

I am using MySQL.

Below is a screen shot of my power chart:

jball · January 27, 2021, 1:25am

It would be in the query you have setup to build the table in MySQL that you’re using to create your DB historian.

neill · January 27, 2021, 2:19am

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:

My database table:

What format must the t_stamp be?
I am currently using the inbuilt DateTime datatype.

Thoughts?

jball · January 27, 2021, 5:06pm

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.

neill · January 28, 2021, 1:58am

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

Maybe this is a bug?

neill · January 28, 2021, 2:00am

Apparently started fine:

State is unknown for some reason:

neill · January 28, 2021, 3:45am

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”.

jball · January 28, 2021, 5:31pm

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.