Creating per minute average values from 10 every second timestamp

[#1]

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? 

AlphaPanda86751_0-1665743269802.png

[#2]

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:

jthi_1-1665743724509.png

jthi_2-1665743749004.png

jthi_3-1665743759646.png