Yanmin Xu Posted January 28, 2021 Share Posted January 28, 2021 Hi Seeq, I am new to Seeq and have two questions regarding the "Time" variable/signal. 1. In csv file, the first column is always Date/Time, and this "time column" can be used in subsequent analysis (ex. derivative, avg, complex formula). I don't know how this "time column" is treated in Seeq (seems to me by default is the x-axis). Can we create a signal that include this time information? 2. How can time be used in correlating different signals? Let's say I have signals A&B and want to calculate a new signal C. Is it possible to do so in Seeq? Time A B C t1 a1 b1 - t2 a2 b2 =(b2-b1)/(a2-a1) t3 a3 b3 =(b3-b2)/(a3-a2) Thanks for your help! Yanmin Link to comment Share on other sites More sharing options...
Seeq Team Kristopher Wiggins Posted January 28, 2021 Seeq Team Share Posted January 28, 2021 Hi Yanmin, For your first question, yes your time column is treated as the x-axis in Seeq. As a result, every signal that is trended in Seeq naturally incorporates this time column as its x-axis. When you say "create a signal that includes this time information" are you thinking of having time on the y-axis as well? For your second question, yes we can. Seeq has a function called runningDelta(), which calculates the difference of successive samples. So in your scenario, (b2-b1) would be captured by $b.runningDelta(). (b2-b1)/(a2-a1) would also be $b.runningDelta()/$a.runningDelta(). This would all be done in Seeq's Formula tool. Hopefully the example screenshot below helps. If you'd like help understanding or would like to discuss more, please come to our office hours where a member of our team can help you. https://info.seeq.com/office-hours Regards, Kris 2 Link to comment Share on other sites More sharing options...
Yanmin Xu Posted January 29, 2021 Author Share Posted January 29, 2021 Hi Kris, Thanks for the reply. In reality, different signals may have different frequencies. And sometimes there is lack of data for a period of time just due to measurement failure. Time Signal A Signal B t1 a1 - t2 a2 b1 t3 failure - t4 a4 b2 So for question 1, what I was thinking is to check if we have data at a specific time. In csv file, we can filter the time we wanted, and check the data. Is it possible in Seeq? For question 2, if I want to create signal C=(b2-b1)/(a4-a2), how should I deal with it? Can runningDelta() help? Thanks! Regards, Yanmin Link to comment Share on other sites More sharing options...
Administrators Lindsey.Wilcox Posted January 29, 2021 Administrators Share Posted January 29, 2021 Hi Yanmin- Question 1: You can find more information about the CSV import tool in our Knowledge Base: https://support.seeq.com/space/KB/537690127/Import%20CSV%20Files. When you use this tool to import data, you can specify how you would like Seeq to handle "invalid" data (like the failure or null values you described). For the example you provided, I think you would want to select "Skip". Once the data is imported Signals A & B will only have data points where there is valid data. Question 2: The .runningDelta() operator calculates the difference between adjacent samples, as you described in your post. More information can be found in the Formula documentation. Please let me know if you have any additional questions. Thanks, Lindsey 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