Roundoff decimal option in splunk dashboard using XML query

[nnimbe]

We have created some of the dashboards like top allowed source, top allowed destinations using XML ,

option name="charting.chart.showPercent , will provide the percentage in that dashboard

but currently it is showing 3 decimal places like 2.123% or 43.456%, i want to round off or to display two decimal places like 2.12% or 43.46%,

how this could be achieved by tweaking the XML query, please suggest

[woodcock]

It cannot.

[gcusello · Accepted solution]

Hi nnimbe,
you can round your numbers in two ways:

• in a table using number formatting functionality in Modify panels;
• in search using | eval number=round(number,2)

Bye.
Giuseppe

[nnimbe]

@cusello , thanks,

in a table using number formatting functionality in Modify panels;---- We are using pie chart and i am not seeing this option, can u pls suggest to modify the XML queries if we are using the pie chart

in search using | eval number=round(number,2)--- this is fine when we are using search

[gcusello]

Hi nnimbe,
for Pie Charts there isn't a functionality like tables.
Bye.
Giuseppe