I got a problem with SPLIT when 1 column was not included in Group. I intended to make it not in Group and hope it the values in another column can be averaged.
So I made a sample Data Table to play and try to understand what's going on.
Sample table below:
![Zihao_0-1660942071216.png Zihao_0-1660942071216.png](https://community.jmp.com/t5/image/serverpage/image-id/44886iBF22966E072C3A31/image-size/medium?v=v2&px=400)
Scenario1:
I want to Split "Random metric value", Split by Tool A&B, Group by only "Test", and hope the "random metric value" from different iterations can be averaged for the same "Test".
Here is what I got:
![Zihao_1-1660942215670.png Zihao_1-1660942215670.png](https://community.jmp.com/t5/image/serverpage/image-id/44887i4281542DC82252AE/image-size/medium?v=v2&px=400)
Scenario 2:
But when I do manual averaging (Summary-Mean(Random Metric Value) then split by tool A&B), the results are different:
![Zihao_2-1660942335287.png Zihao_2-1660942335287.png](https://community.jmp.com/t5/image/serverpage/image-id/44888i9122E93DD691B727/image-size/medium?v=v2&px=400)
Above should be the right results.
But my question is: what is happening when I do SPLIT in the 1st scenario without cast "Iteration" column anywhere?
Best regards,
Zihao