topic Re: How can I round percentage values in a piechart? in Dashboards & Visualizations

How can I round percentage values in a piechart?

tamduong16 — Thu, 24 Aug 2017 21:37:00 GMT

I have the following piechart:

How can I change it so that the percentage could be round from 33.771% to 34%? And for the rest also?

Re: How can I round percentage values in a piechart?

s2_splunk — Thu, 24 Aug 2017 21:53:21 GMT

This might help. You simply round the values in your SPL query.

Re: How can I round percentage values in a piechart?

DalJeanis — Thu, 24 Aug 2017 22:31:48 GMT

@tamduong16 - One suggestion - you probably want to round to 1 digit after the decimal. It won't be too distracting to the user, and it will avoid questions when the numbers often add up to more than 100.

Most people don't pay attention to adding up decimals, and even if the numbers add up to 100.1 or 100.2, it's less likely to raise questions than a total of 101 or 102. (33.8/42.5/23.7 vs 34/43/24)

Re: How can I round percentage values in a piechart?

jkat54 — Fri, 25 Aug 2017 00:10:05 GMT

Use eval’s round function in your search:

...| eval numberField=round(numberField,0)

The above would round a field called numberField to whole numbers, you could change 0 to however many decimals you want to round to.

Re: How can I round percentage values in a piechart?

tamduong16 — Fri, 25 Aug 2017 13:39:50 GMT

thanks for the advise DalJeanis