Dashboards & Visualizations

how to create a centile chart

cheriemilk
Path Finder

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.

cheriemilk_0-1633937410705.png

 

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?

 

Labels (1)
0 Karma
1 Solution

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

View solution in original post

0 Karma

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

cheriemilk
Path Finder
Thank you~
0 Karma