I have a data set where I would like to use an xy chart for some data that is in a format similar to this
In the chart I’d like to have a separate pen for each Part SN(the number of part SN’s are not fixed) and plot the cycle vs the data. Any ideas?
That would be a group by cycle and pivot on part SN in SQL. You could use the view() expression function’s Pseudo-SQL for this, too. Part of the Simulation Aids module. Something like this:
SELECT Cycle
GROUP BY Cycle
PIVOT Data FOR Part_SN
ORDER BY Cycle