Dashboards & Visualizations
Highlighted

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

Builder

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?

Highlighted

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

Super Champion

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>   
0 Karma
Highlighted

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

Builder

Thanks for the response @cmerriman.

0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

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.

View solution in original post

Highlighted

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

Builder

Thanks for the response @mayurr98. It worked great.

0 Karma