Dashboards & Visualizations

Pie chart - rounding percent values

IgorB
Path Finder

In Splunk 4.3.x pie charts using showPercent=true - is it possible to round up percent values shown on the chart?

Tags (1)

AndyMarr
Explorer

Using SPlunk 6 - it also defaults to 3 decimal places - how to change how many decimals?

0 Karma

lguinn2
Legend

I think this will work:

yoursearchhere
| top abc showperc=true
| eval percent=round(percent,0)
0 Karma

leonjxtan
Path Finder

I downvoted this post because i tried, it does not work.

0 Karma

Parameshwara
Path Finder

Does not work:

index=abc Year=1999 | stats sum(Field1) as NewField by Group | eval NewField=round(NewField,1)

Pie chart still shows as 3 decimal value, as per it's default formatting.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It works, but you have to be sure to use the results of the round() function in your chart.

---
If this reply helps you, Karma would be appreciated.
0 Karma

IgorB
Path Finder

That won't work - pie chart seems to be doing percent calculations on it's own

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...