MWaugh Posted September 16, 2021 Posted September 16, 2021 xyTable($capsule, $xSignal, $ySignal, 100) What is the syntax to enter $capsule in this formula? Thanks.
Andrew Fontenot Posted September 16, 2021 Posted September 16, 2021 See capsule() in the formula documentation.
MWaugh Posted September 16, 2021 Author Posted September 16, 2021 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)
Andrew Fontenot Posted September 16, 2021 Posted September 16, 2021 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.
MWaugh Posted September 16, 2021 Author Posted September 16, 2021 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)
Andrew Fontenot Posted September 16, 2021 Posted September 16, 2021 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.
MWaugh Posted September 16, 2021 Author Posted September 16, 2021 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.
Andrew Fontenot Posted September 16, 2021 Posted September 16, 2021 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?
MWaugh Posted September 17, 2021 Author Posted September 17, 2021 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.
Andrew Fontenot Posted September 17, 2021 Posted September 17, 2021 You should be able to just use the built-in prediction tool under Model & Predict -> Prediction. If there is a delay in the off-line samples and you need to move the signal in time by a constant amount, you can use the $signal.move() function in a formula to create a new time-adjusted signal for use in the Prediction tool. The Prediction Model section of the Prediction tool will show you information regarding the regression such as rSquared, p-values, etc. The Prediction tool should take care of creating the value pairs from the input signals, perhaps a Seeq Engineer can give more specific info on this if needed.
MWaugh Posted September 17, 2021 Author Posted September 17, 2021 20 minutes ago, Andrew Fontenot said: You should be able to just use the built-in prediction tool under Model & Predict -> Prediction. If there is a delay in the off-line samples and you need to move the signal in time by a constant amount, you can use the $signal.move() function in a formula to create a new time-adjusted signal for use in the Prediction tool. The Prediction Model section of the Prediction tool will show you information regarding the regression such as rSquared, p-values, etc. The Prediction tool should take care of creating the value pairs from the input signals, perhaps a Seeq Engineer can give more specific info on this if needed. 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.
Andrew Fontenot Posted September 29, 2021 Posted September 29, 2021 xyTable does return a table. According to the error though, the Formula tool cannot. It looks to me like the functions that return Tables are mainly used underneath the hood to create histograms. But I agree, I'm not sure why formula can't return a table either. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now