MWaugh Posted September 16, 2021 Share Posted September 16, 2021 xyTable($capsule, $xSignal, $ySignal, 100) What is the syntax to enter $capsule in this formula? Thanks. Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 16, 2021 Share Posted September 16, 2021 See capsule() in the formula documentation. Link to comment Share on other sites More sharing options...
MWaugh Posted September 16, 2021 Author Share 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) Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 16, 2021 Share 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. Link to comment Share on other sites More sharing options...
MWaugh Posted September 16, 2021 Author Share 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) Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 16, 2021 Share 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. Link to comment Share on other sites More sharing options...
MWaugh Posted September 16, 2021 Author Share 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. Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 16, 2021 Share 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? Link to comment Share on other sites More sharing options...
MWaugh Posted September 17, 2021 Author Share 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. Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 17, 2021 Share 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. Link to comment Share on other sites More sharing options...
MWaugh Posted September 17, 2021 Author Share 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. Link to comment Share on other sites More sharing options...
Andrew Fontenot Posted September 29, 2021 Share 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 Link to comment Share on other sites More sharing options...
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