キャンセル
次の結果を表示 
表示  限定  | 次の代わりに検索 
もしかして: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
言語を選択 翻訳バーを非表示
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 件の受理された解決策

受理された解決策
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

元の投稿で解決策を見る

3件の返信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

おすすめの記事