How to view percentage row to table?

[SplunkNewbie18]

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%

[HiroshiSatoh · Accepted solution]

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"

[mayurr98]

how did you get this table? and can you tell me what are the fields and values in that table?