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!

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

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...