Dashboards & Visualizations

Drill down using sum of values

umsundar2015
Path Finder

Hi ,
I have values like

Failure Ignored Partial Success
0 803 23 0
24 0 0 0
192 1 0 0
23 6 21 45
3 2 4 31
5 89 4 85

My requirement is to create a pie chart with the above values ( i mean with each column total count).These total columns should be
Show breakdown by Success/ Failure / Partial Success / Ignored. Show a pie chart for the week

with above data , i need to create a drill down for the above piechart

When i select anyone of the above values like (Success,Failure,Ignored,Partial) ,I have the row value as Name which has machine name as its values.

My search is ,
index=macqw2|fillnull|search name="Saqpedc102" |eventstats sum(Current_Failure) as Failure,sum(Current_Ignored) as Ignored,sum(Current_Partial) as Partial,sum(Current_Success) as Success |transpose|Rename "column" as Delta|search Delta="Ignored"|table Site Partial Success Failure Ignored

I am getting error for this when i click th pie chart .Please help me with the search

0 Karma

diogofgm
SplunkTrust
SplunkTrust

You can drill down to a custom search.

check this docs:
http://docs.splunk.com/Documentation/Splunk/7.1.1/Viz/DrilldownLinkToSearch

------------
Hope I was able to help you. If so, some karma would be appreciated.
0 Karma

umsundar2015
Path Finder

Thank you for the search .But i am in need of search which automatically picks the values and provide the drill down.

Pls provide me that search .

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...