Hi,
I've read through transpose command to try suit into the statistics I would want to view but it doesn't seems to work.
I'm having the following data in a form of table:
Table A B
Cases 1 4
Percentage 20% 80%
How do I make the Percentage to be part of a column like:
Table A Percentage A B Percentage B
Cases 1 20% 4 80%
If you simply convert
(your search)
|table Table A B
|stats values(*) as *
|eval Table=mvindex(Table, 0)
|eval Cases_A=mvindex(A, 0),"Percentage A"=mvindex(A, 1)
|eval Cases_B=mvindex(B, 0),"Percentage B"=mvindex(B, 1)
|rename Cases_A as A,Cases_B as B
|table Table A "Percentage A" B "Percentage B"
If you simply convert
(your search)
|table Table A B
|stats values(*) as *
|eval Table=mvindex(Table, 0)
|eval Cases_A=mvindex(A, 0),"Percentage A"=mvindex(A, 1)
|eval Cases_B=mvindex(B, 0),"Percentage B"=mvindex(B, 1)
|rename Cases_A as A,Cases_B as B
|table Table A "Percentage A" B "Percentage B"
how did you get this table? and can you tell me what are the fields and values in that table?