topic Re: Only show percentages when using pie chart in Splunk Search

Only show percentages when using pie chart

bharathkumarnec — Fri, 26 Jan 2018 13:58:58 GMT

Hi All,

My requirement is to display only percentages in the pie chart not the label names.

I tried below two options:

<option name="charting.chart.showPercent">true</option>
 <option name="charting.chart.showLabels">false</option>

but they are not working as expected.

Kindly help me out if there is any work around?

Regards,
BK

Re: Only show percentages when using pie chart

mayurr98 — Fri, 26 Jan 2018 14:10:26 GMT

hey
It will show only when showlabels is enabled.
have a look at this doc
https://docs.splunk.com/Documentation/Splunk/7.0.1/Viz/ChartConfigurationReference#Pie_charts

but i must say this is totally possible using search query!
try this run anywhere search and look visualization as pie chart

index=_internal | stats count by log_level | eventstats sum(count) as total | eval count=round(100*count/total,2) |fields- total | eval log_level="".count."%"

and set this parameters in XML

<option name="charting.chart.showPercent">false</option>
<option name="charting.chart.showLabels">true</option>

let me know if this helps!

Re: Only show percentages when using pie chart

mayurr98 — Fri, 26 Jan 2018 15:17:53 GMT

I have given you a work around pls check and let me know!

Re: Only show percentages when using pie chart

bharathkumarnec — Mon, 29 Jan 2018 10:38:14 GMT

Thanks for the information @mayurr98

This i have tried but could not help me in getting my actual requirement.

Single column with values will not display anything in the pie chart, pie chart is showing values or percentages with field names.

But in my case i dont need field names just a value from the column.

Regards,
BK

Re: Only show percentages when using pie chart

niketn — Mon, 29 Jan 2018 10:42:38 GMT

@bharathkumarnec, can you please provide what is the query you have right now?

Re: Only show percentages when using pie chart

mayurr98 — Mon, 29 Jan 2018 10:52:18 GMT

give me your search query.

Re: Only show percentages when using pie chart

niketn — Mon, 29 Jan 2018 10:53:55 GMT

@bharathkumarnec, if you do not have percent field in your existing stats then you will have to calculate the same. As the final pipe of your search you should perform an eval for your label field and assign value of the percent field

 | eval <yourLabelField>= <yourPercentField>." %"

Following is a run anywhere example based on Splunk's _internal index:

index=_internal sourcetype=splunkd log_level=*
| stats count by log_level
| eventstats sum(count) as total 
| eval perc=round((count/total)*100,1)
| eval log_level=perc." %"
| fields - total perc

Re: Only show percentages when using pie chart

bharathkumarnec — Mon, 29 Jan 2018 20:19:26 GMT

@mayurr98, sorry it is working fine..i missed something and have corrected it. Thanks a lot for the help.

Re: Only show percentages when using pie chart

bharathkumarnec — Mon, 29 Jan 2018 20:19:46 GMT

@niketnilay, Thanks a lot for the help.

Re: Only show percentages when using pie chart

bharathkumarnec — Wed, 31 Jan 2018 10:19:42 GMT

@niketnilay,

Is there a way that i can use the same colors of the pie chart percentages and labels those are separately written beside pie chart using html?

Regards,
BK