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!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...