Teddy

Jitesh,

What version of Seeq are you using?

Teddy

Jitesh,

I am not 100% sure if this is what you are looking for, but you can just increase the max interpolation and Seeq will draw the line. See screen shots below for details.

I should mention that knowledge of planned future calculations should be considered along with why the data was removed.  Different methods for filling gaps in the data will result in slightly different outcomes in the end results.  This should be considered before determining how to fill in missing data e.g. (splicing like suggested above or adjusting interpolation). 

Starting point (I remove the spikes around the edges as well for this.)

To remove the edges, you can do the following.

$Time= 1day  //Time needed to grow your condition to exclude the spikes at the edges.

$signal.remove($RemoveCondition.grow($Time))

Once you have your cleaned signal you can set the max interpolation in the formula tool. The following syntax will change the interpolation. Note you may need to adjust time for your own problem.

$signal.setMaxInterpolation(3weeks)

The results

Overlaid

Hope this helps,

Teddy

Jitesh,

Unfortunately, at this time Seeq doesn’t support multiple column imports at a time through the csv import tool.  It is something we plan to have in future versions of the product, but I don’t know when it will be available.

It is possible to import multiple columns at one time with the directory watch tool.  However, its setup takes some time and only makes sense if there are a bunch of csv files with the exact same format. 

Regards,

Teddy

The simplest method for filtering a signal to only view samples with values above a threshold is to use the .remove() function coupled with a numeric value comparison in formula. 

Example formula:

Resulting signal:

Another method is to use the .remove() function in combination with a condition. This gives some added flexibility to further customize the condition you are removing data during vs just removing data under a certain threshold.

Example using .grow() to increase the duration of the condition that data is being removed during:

Resulting signal: 

Depending on interpolation of the data, you could also consider using the .within() function. Check out the following post that explains the differences of working with .remove() and .within():

Content Verified DEC2023

Hello Ruben,

To best answer this question, we would need to look at your current look up table.  If you are uncomfortable sharing it on a public site, I recommend opening a support ticket here.  You can just copy and paste the text into the ticket.

Normally we recommend using an equation to replace the look up table.  However, there are some cases where other approaches are needed. 

Regards,

Teddy

Thorsten,

It looks as if the second part of your code requires summing values at different keys (timestamps).  At this time Seeq can only pass data for external calculations one key at a time so functions like summing data over time aren't possible because you need more than one key.  

I recommend doing the summation in Seeq as Lindsey suggested.

Regards,

Teddy