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
Andy8
Level I

How to take mean of columns based on DateTime?

Greetings!

 

I have a large dataset, a snippet of which looks like this: 

Andy8_0-1662918693824.png

I want to take the mean of each of the 7 P-P and RMS columns that have the same DateTime.  Since there are 4 unique DateTimes in the data, this would result in a table with 4 rows.  Ideally SN column would be preserved.  I suspect Tables->Summary may hold the key, but I can't get it to do what I want.  I have been able to get the result I want using Formula columns, but this is a frequent need with lots more columns and Formula columns get cumbersome quickly.

 

Thank you!

Andy

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to take mean of columns based on DateTime?

Summary (or tabulate) should work. What issues are you having with Summary table?

jthi_0-1662921045274.png

jthi_1-1662921053712.png

jthi_2-1662921060828.png

 

-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: How to take mean of columns based on DateTime?

Summary (or tabulate) should work. What issues are you having with Summary table?

jthi_0-1662921045274.png

jthi_1-1662921053712.png

jthi_2-1662921060828.png

 

-Jarmo
Andy8
Level I

Re: How to take mean of columns based on DateTime?

Thank you. Your example made it clear.  I was dropping the wrong columns in the wrong boxes.

jthi
Super User

Re: How to take mean of columns based on DateTime?

One suggestion I have is to check the "Keep Dialog Open". Then just try dropping different columns to different places to see what happens, for example move SN to Subgroup instead of Group. Having enabled "Keep Dialog Open" makes it much easier and faster to test different approaches. Sometimes "Help" button is also very useful and will provide explanations and examples.

-Jarmo