topic Re: How to round the decimal percentage in a piechart with XML? in Dashboards & Visualizations

How to round the decimal percentage in a piechart with XML?

pavanae — Wed, 08 Nov 2017 20:28:38 GMT

I had a pie-chart and I have added the following line on the source to display the percentage on the piechart But the percentage is displaying as xx.xyz. Now, how can I round it to single digit likle xx.y

option name="charting.chart.showPercent" as true

Is there any way to round the percentage from the xml?

Re: How to round the decimal percentage in a piechart with XML?

cmerriman — Wed, 08 Nov 2017 21:15:44 GMT

try the number formatting options:
https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Viz/TableFormatsXML#Number_format_rules

<format type="number" field="count">
        <option name="precision">1</option>
</format>

Re: How to round the decimal percentage in a piechart with XML?

mayurr98 — Thu, 09 Nov 2017 05:52:48 GMT

As of now, there is no property to add precision in XML for a pie chart.
you can look for doc here https://docs.splunk.com/Documentation/Splunk/7.0.0/Viz/ChartConfigurationReference#Pie_charts
One way to do this using query.

index=your_index | stats query | eventstats sum(count) as total_Count | eval total_Count=round((count/total_Count)*100,2) | eval field=field + " , " + total_Count + "%"

here the name of the field will be the name which is given after by clause in stats command.

Let me know if it works.

Re: How to round the decimal percentage in a piechart with XML?

pavanae — Thu, 09 Nov 2017 19:31:10 GMT

Thanks for the response @mayurr98. It worked great.

Re: How to round the decimal percentage in a piechart with XML?

pavanae — Thu, 09 Nov 2017 19:32:41 GMT

Thanks for the response @cmerriman.