Chart Report SQL Vision

Hello All,

I need your help with something that is giving me a headache.

I need to graph the data of 3 encoders in the same graph Axis X: Time and Y:Value

Currently I have the data in different SQL tables
image

In ignition reporting I'm trying with Named Queries
image

But it just graph the first set because I just can put one data key

image

I tried with SQL UNION but it sends me a huge table with a lot of repeated data, I tried with just one table with all the data and one additional column for each Encoder (Encoder1, encoder 2, encoder3)

image

But the same thing, There is no way to select just the data of the encoder 1 or 2 etc.

image

Do you know how can I Graph my data of the 3 encoders in the same graph?

Thank you

Well it was not possible because the date data in each tables wasn't the same so I did 3 different charts in my report and the customer preferred in this way.

1 Like