combine multiple values

ConcurrentSteer — Sat, 10 Jun 2023 23:48:25 GMT

Hey,

I have a question about how to combine double reporting in JMP:

lets say that I have an output of 3 colums: row_index, column_index and value.

and for some reason the out put has double reporting issue of row and columns, for example:

Row Column Value

1 1 3

1 2 5

1 3 7

1 3 7.2

Notice that I have a double reporting in the last row (2 times 1,3).

Is there a way to combine them into 1 row and make the value an average of them?

Thanks!

Re: combine multiple values

txnelson — Wed, 18 May 2022 02:43:10 GMT

Use

Tables=>Summary