Problem with Pie Chart

[strive]

Hi,

I read through the pie chart docs in splunk. I am not able to customize it to my needs.

My Search query is:

first search part | stats sum(A) as Total A, sum(B) as Total B

A and B are two separate fields in summary index.

The result set looks like this:

A   B
10  20

To display this as pie chart, i need the result set as

Label   Value
 A       10
 B       20

What can i pipe to my search query so that i get result set as mentioned above.

Thanks

Strive

[strive · Accepted solution]

I did it. I used |transpose and it worked.