Dashboards & Visualizations

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

pavanae
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?

1 Solution

mayurr98
Super Champion

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

mayurr98
Super Champion

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.

pavanae
Builder

Thanks for the response @mayurr98. It worked great.

0 Karma

cmerriman
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

pavanae
Builder

Thanks for the response @cmerriman.

0 Karma
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...