how to create a centile chart

[cheriemilk]

Hi team,

I am using below  query  to display the value for perc25, perc50, perc75 and perc95  for 'latency' field for different subscribers.

<base query>
|chart perc25(latency) perc50(latency) perc75(latency) perc95(latency) by subscriber

the chart splunk returned is below, but it is not what I want.

My expected chart is below. I want :

1.  25, 50, 75 and 95 as the rating scale of x-axis, instead of subscribers.

2. Y axis to display the value returned by perc25, perc50, perc75 and perc95

2. subscribers as legends, instead of perc25, perc50, perc75 and perc95.

How to get this chart?

[ITWhisperer · Accepted solution]

<base query>
|chart perc25(latency) perc50(latency) perc75(latency) perc95(latency) by subscriber
| transpose 0 header_field=subscriber

[cheriemilk]

Thank you~