cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar

Creating per minute average values from 10 every second timestamp

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

 

1 REPLY 1
jthi
Super User

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

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

 

 

 

 

-Jarmo