Creating per minute average values from 10 every second timestamp

Report Inappropriate Content · Jun 10, 2023 4:55 PM

Hi,

I have data appearing 6 times every 10 second and I want to convert that as a per minute data.

Can you please help me with that?

jthi · Oct 14, 2022 06:37 AM

If you want to remove seconds and then calculate the average you can create new column with formula such as

:Time - Second(:Time)

to remove seconds from the timestamp. Then aggregate them with Summary table for example:

-Jarmo

Re: Creating per minute average values from 10 every second timestamp