Dashboards & Visualizations

Pie chart help

Marco
Communicator

Hi Splunkers,

I am currently trying to create a pie chart that gets its data from a token:

host=* | eval $Overview$ | chart sum(Warning) as "Warnings"  sum(Violation)  as  Violations sum(Alerts) as Alerts  over sum(ALL)

I am looking to create a pie chart that shows these three values. Any help is appreciated 

 

Thank you,

Marco

Labels (5)
0 Karma
1 Solution

Marco
Communicator

Hi Splunkers,

I found the solution:

host=* | eval $Overview$ | chart sum(Warning) as "Warnings"  sum(Violation)  as  Violations sum(Alerts) as Alerts | transpose

 

I was missing the transpose command.

Thank you,

Marco 

View solution in original post

0 Karma

Marco
Communicator

Hi Splunkers,

I found the solution:

host=* | eval $Overview$ | chart sum(Warning) as "Warnings"  sum(Violation)  as  Violations sum(Alerts) as Alerts | transpose

 

I was missing the transpose command.

Thank you,

Marco 

0 Karma

to4kawa
Ultra Champion

sample:

| makeresults count=20
| eval Warning = random() %  20,Violation = random() % 20, Alerts = random() % 20
| rename COMMENT as "The sample. from here, the logic."
| chart sum(Warning) as "Warnings"  sum(Violation)  as  Violations sum(Alerts) as Alerts
| eval tmp="1"
| untable tmp Status Count
| fields - tmp
| rename COMMENT as "Viz >> Pie Chart"
0 Karma
Get Updates on the Splunk Community!

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...

Stay Connected: Your Guide to February Tech Talks, Office Hours, and Webinars!

💌Keep the new year’s momentum going with our February lineup of Community Office Hours, Tech Talks, ...

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...