Splunk Cloud Platform

Custom Pie Chart

Path Finder

I have  a requirement where I have to show a pie chart which shows pending/opened/assigned service request from last Feb to till now but the time span should be 40, as well as which services are older than 80 days. it will come in ">80" legend. Like in this way only (0-40, 40-80, >80)


My Search query is : 

index a
| table a b c d        [a b c d stands for a=user, b=date, c=service request number and d=days]
| chart count(c) by d span=40  


My Output :

days                 count(number)
0-40                          3111
40-80                       2252
80-120                      478
120-160                 2757

But I want my output in manner :
days                 count(number)
0-40                          3111
40-80                       2252
>80                           3235 (478+2757)


Is it possible to get my desired output in the pie chart?

Please give me an example with a search query if we can do that. 

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...