Charting - Trends XY

Dear All,

I have a requirement where I need to plot the parameter (temp, pressure, energy, power, speed) data collected from the machine for a batch against the cycle time, which starts from 0 - 200 seconds.

I am logging the data by enabling history in a SQL Server. This is stored against a timeseries. I have the batch start and stop time, using which I can get the parameters.

Attached screenshot is the expectation, where on the left side is the list of batches and on the right side, i need to show the trend for all the selected batches with x-axis as cycle time and y-axis as parameters, which i should have an option to check or uncheck.

I tried easy chart, but the x-axis seems only to be on a time series. Could you kindly direct me a possible way to get this done in ignition vision/perspective? Thanks.

CycleId Timestamp CycleTime Pressure Temp
1 3/22/2021 23:47 10 55 74
1 3/22/2021 23:48 20 48 51
1 3/22/2021 23:49 30 75 62
1 3/22/2021 23:50 40 15 95
2 3/23/2021 9:47 10 55 74
2 3/23/2021 9:48 20 48 51
2 3/23/2021 9:49 30 75 62
2 3/23/2021 9:50 40 15 95

One Idea i can suggest is, If you create a structure for the data like the one shown above,
For Left Side
Using the CycleId, You can provide required cycle selections.
For Right Side
And for plotting you can use classic chart, Chart type : XY Plot
-Create a Number axis as X axis
-First Column in data will be considered for X axis so keep Cycle time as first column
-Store other data in the adjacent columns.

If you are using transaction groups storing data in the mentioned format will be very easy.

There may be many better options out there. Thanks.

1 Like