Monitoring Splunk

CPU Pie Chart

jlaigo2
Path Finder

Have been trying to get a pie chart that reps the cpu usage. IE the following log format.
Any one have a clue if I can create a pie chart with a multikv fields?

CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
avg 0.74 8.0% 2.8% 11.8% 77.4% 0.0% 0.0% 0.0% 0.0%

Tags (1)
1 Solution

Ayn
Legend

Assuming you have the fields extracted, you can use transpose to get a chart formatted in a way that can be used for a pie chart. Since a pie chart doesn't deal with time-series data, it will use only the first row of the table it's supplied with. It's cleaner to add | head 1 to the search to show explicitly what data is used for the pie chart though.

<yourbasesearch> | head 1 | table USER NICE SYS IDLE BLOCK SWAIT INTR SSYS | transpose

View solution in original post

jlaigo2
Path Finder

Works perfect thanks for the help:)

0 Karma

Ayn
Legend

Assuming you have the fields extracted, you can use transpose to get a chart formatted in a way that can be used for a pie chart. Since a pie chart doesn't deal with time-series data, it will use only the first row of the table it's supplied with. It's cleaner to add | head 1 to the search to show explicitly what data is used for the pie chart though.

<yourbasesearch> | head 1 | table USER NICE SYS IDLE BLOCK SWAIT INTR SSYS | transpose
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...