Splunk Search

How to make a Simple Pie Chart showing the percent on the pie

mikeoks
New Member

Im trying to create a simple Pie chart from a csv file or indexed data and cant seem to configure the Pie chart correctly.

the Beer.csv looks like this
Name,Amount
BeersDrank,56
BeersRemaining,6
BeersWasted,12

| inputlookup Beer.csv | chart Values(Amount) by Name

this makes a pie chart that seems to allocate the correct proportion but how can i make it write the actual percent on the pie chart and the number for that name?

thanks for any help

0 Karma

to4kawa
Ultra Champion
| inputlookup Beer.csv 
| eventstats sum(Amount) as total
| eval perc = (Amount / total * 100)
| table Name,Amount, total, perc
`comment("if you want,")`
| table perc, Amount

Visualization > Pie Chart
Hi, @mikeoks
I'm not sure what you want.
how about this?

0 Karma
Get Updates on the Splunk Community!

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...