MWaugh

Yeah, I first tried the Prediction route, and didn't get anywhere. I'll have to revisit. But I'm still confused as to why xyTable can't return a table.

I have an in-line instrument value from the historian, at roughly four per minute. Simultaneously, off-line samples are measured using a different technology, so the scaling of the two measurements is different. These samples are measured by hand, minutes apart. The off-line samples are imported to the Workbench in a csv file, so the time stamps don't necessarily line up exactly with any of the in-line values from the historian. My goal is to determine the correlation between the two measurements, with the off-line sample measurement being the gold standard, and attempting to "prove out" the in-line measurement.

I already have a visual of the data in Workbench. What I want to do with the table is to get the data in a format that will be easier to do formulas against.

I am trying to accomplish what the documentation says this function does: xyTable() Create a table of aligned samples from two signals." And this is the example formula given: xyTable($capsule, $xSignal, $ySignal, 100)

Thank you for your response. Can you show the syntax in the xyTable formula? This does not work: xyTable(capsule('2021'), $qs5, $a, 100) And this does not work: xyTable($capsule('2021'), $qs5, $a, 100)

xyTable($capsule, $xSignal, $ySignal, 100) What is the syntax to enter $capsule in this formula? Thanks.