topic Re: Pie chart - rounding percent values in Dashboards & Visualizations

Pie chart - rounding percent values

IgorB — Wed, 31 Oct 2012 13:18:27 GMT

In Splunk 4.3.x pie charts using showPercent=true - is it possible to round up percent values shown on the chart?

Re: Pie chart - rounding percent values

lguinn2 — Wed, 31 Oct 2012 14:26:23 GMT

I think this will work:

yoursearchhere
| top abc showperc=true
| eval percent=round(percent,0)

Re: Pie chart - rounding percent values

IgorB — Wed, 31 Oct 2012 14:42:32 GMT

That won't work - pie chart seems to be doing percent calculations on it's own

Re: Pie chart - rounding percent values

richgalloway — Thu, 28 Feb 2013 13:45:04 GMT

It works, but you have to be sure to use the results of the round() function in your chart.

Re: Pie chart - rounding percent values

Parameshwara — Mon, 25 Mar 2013 03:02:00 GMT

Does not work:

index=abc Year=1999 | stats sum(Field1) as NewField by Group | eval NewField=round(NewField,1)

Pie chart still shows as 3 decimal value, as per it's default formatting.

Re: Pie chart - rounding percent values

leonjxtan — Thu, 03 Aug 2017 05:15:10 GMT

I downvoted this post because i tried, it does not work.

Re: Pie chart - rounding percent values

AndyMarr — Tue, 26 Sep 2017 19:35:29 GMT

Using SPlunk 6 - it also defaults to 3 decimal places - how to change how many decimals?

Re: Pie chart - rounding percent values

BeautyData — Mon, 13 May 2024 13:55:57 GMT

I have the same need right now. I am wondering if do you have resolved that after this time? I am trying to round,2 but looks like that Splunk visualization do that in their own, going default to round,3

I appreciate any help.

Thank you