topic How to take mean of columns based on DateTime? in Discussions

How to take mean of columns based on DateTime?

Andy8 — Sat, 10 Jun 2023 23:54:04 GMT

Greetings!

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

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

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

jthi — Sun, 11 Sep 2022 18:31:49 GMT

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

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

Andy8 — Sun, 11 Sep 2022 20:08:59 GMT

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

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

jthi — Sun, 11 Sep 2022 20:13:03 GMT

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.