MWaugh
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Library
Downloads
Gallery
Posts posted by MWaugh
-
-
15 hours ago, Andrew Fontenot said:
So what is your objective, what signal/scalar/condition do you want to the formula to output? xyTable will produce a table of value pairs for your two signals, what are the next steps required to produce the signal/scalar/condition?
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.
-
3 hours ago, Andrew Fontenot said:
That's exactly what the formula does, it returns a table, but this is different from the Table View in Seeq Workbench. It's purpose is not to create a graphical table in Workbench.
If you are trying to create a graphic table of samples, I'm not sure if this is your objective, you could use Table View in Condition Mode to do this. One way, would be to create a Score Card Metric for each signal and specify the rolling window for which you'd like a value in your table. Here's an example.
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.
-
5 minutes ago, Andrew Fontenot said:
What are trying to accomplish? This formula returns a table, but Seeq expects a condition, formula, or scalar so I imagine you are seeing the bad response error because of this.
xyTable(capsule('2021'), $a, $b, 100) is the correct syntax, but you can't return a table.
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.
xyTable Function
in General Seeq Discussions
Posted
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.