Forum Discussion

Copper Contributor

Jun 12, 2018

Solved

Averaging values as a function of milliseconds of time to seconds of time

I have data that was created every 100 or so milliseconds over 5 minutes (about 3k data points). I want to average all data within a length of a second into a single data point. here is an exam...

excel

Formulas and Functions

Eitan Laredo
Jun 13, 2018
Solution:
Highlight your data and make it into a table (Ctrl T) > Data > From Table (Above Get & Transform)

With the Time column selected, Transform > Extract > First characters > 8 > OK

With the Value column Selected > Transform > Group By > Group by: Time, New Column Name: Average, Operation: Average, Column: Value > OK

Home > Close & Load

Now, all that you have to do is add new data to the bottom of your table and click refresh then your PQ table will be updated.

Eitan Laredo

Copper Contributor

Jun 13, 2018

Solution:

Highlight your data and make it into a table (Ctrl T) > Data > From Table (Above Get & Transform)

With the Time column selected, Transform > Extract > First characters > 8 > OK

With the Value column Selected > Transform > Group By > Group by: Time, New Column Name: Average, Operation: Average, Column: Value > OK

Home > Close & Load

Now, all that you have to do is add new data to the bottom of your table and click refresh then your PQ table will be updated.