Solutions for displaying SQL queries on Chart?

Ignition
1

Ignition 7.9.6

Hey folks,

I’m dealing with some current and historical SQL data that can be unioned (identical tables, one having older timestamps than the other). The queried dataset consists of several numerical columns, a categorical column, and a timestamp. It appears as though this should be supported by the Chart component, but not Easy Chart.

I already have a functioning easy chart (see below), but it only references one of the data tables. Ideally, the chart with the unioned data would display the data similarly to the existing chart.

Easy%20Chart
Easy%20Chart836×480 21.7 KB

So far, I’ve run into roadblocks displaying the categorical “Cool/Heat” properly and along side the numerical data. Can anyone offer any guidance, or refer me to a resource for resolving this?

Cheers,
Andrew

2

Consider doing the union and any necessary massaging as a view in the database. DB pens in the easy chart can pull from a view as if it is a table.

1 Like
3

Thanks, Phil. That’s an idea I had not considered. I have not worked with views much, but it appears as though I could leave this view active and any time it is queried by a user, it will update?

I’ll look into the details and see where I get. Thank you.

4

Thanks again, Phil. That worked flawlessly!