Dashboards & Visualizations

How to create Splunk table to piechart?

Marco_Develops
Path Finder

Currently, I have a Table that gives me Severity Categories. 

Sevcat I Sevcat II Sevcat III
5 10 12

 

I'm using the following SPL to generate this table:

 

|eval CATI = if(SEVCAT="I", 1,0) 
|eval CATII = if(SEVCAT="II", 1,0)
|eval CATIII = if(SEVCAT="III", 1,0)
|stats sum(CATI) as "Sevcat I" sum(CATII) as "Sevcat II" sum(CATIII) as "Sevcat III"
|table "Sevcat I" "Sevcat II" "Sevcat III"

 

Is there some way to convert this table into a piechart. 

Any help is appreciated 🙂
-Marco 

Labels (3)
0 Karma
1 Solution

somesoni2
Revered Legend

Give this a try

.. Your base search..
|eval SEVCAT = "Sevcat ".SEVCAT
| stats count by SEVCAT

View solution in original post

somesoni2
Revered Legend

Give this a try

.. Your base search..
|eval SEVCAT = "Sevcat ".SEVCAT
| stats count by SEVCAT
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...

span_metrics: The OpenTelemetry-Idiomatic Way to See Inside Your Services

You open a trace in Splunk Observability Cloud and everything looks fine. One root span, order-pipeline, with ...