  # David Edelman

Members

3

## David Edelman's Achievements

1. Thanks - I was not using "ungridded". Now the signal count from Seeq matches the number of data points directly from PI.
2. I am pulling in a relatively noisy signal, and trying to get a feel for how many raw data points I am looking at (to compare with how many points I see after several transformations). However, the "Count" column on the "Tables and Charts" view is way off of the number of records I get if I export that signal through "Import/Export" to Excel. For example, for a signal shows "Count" of 2,343, but when I export that signal to Excel, there are 14,580 timestamps with a value. Even if I remove duplicates (thinking it is a distinct count) there are 3,908 values. Is there something I need to do on the Seeq side to get an accurate count of the data points? Thanks, David
3. Hi - I am new to Seeq but have completed the Foundations course. I am trying to calculate the average of a signal over a 12 hour period. Since "Periodic -> Hours" only produces one capsule per day, I created 2 conditions, both Periodic -> Hours (12), with the second (\$Second12h) offset from midnight by 12 hours. I then was able to calculate the average with this formula, averaging the 12 hour averages average( \$signal.aggregate(average(), \$First12h, startkey()), \$signal.aggregate(average(), \$Second12h, startkey()) ) Is there a more elegant way of doing this? I actually want to shrink down the periods to 6 hours or lower, so trying to see if I will need to create a large number of conditions (24/x conditions, where x is the length of the period in hours) Thanks! David Edelman.
×