Dashboards & Visualizations

Editing number precision in the source dashboard editor-Why is my precision option not persisting but other options are?

MDSplunkNinja
Explorer

Hello,

I have a dashboard which has one panel displaying a statistics table.  The table is very wide (~300 numeric columns) which makes manually editing the number precision for each column prohibitive in the UI.  I attempted to do this in the source editor but the number precision I input does not translate to the table in the panel after saving.

Here is a sample block of code I am inserting:

 

<format type="number" field="xxxxx_percent">
<option name="precision">0.000</option>
<option name="unit">%</option>
<option name="unitPosition">after</option>
</format>

 

and the result looks like this:

MDSplunkNinja_0-1660935189351.png

Anyone know why my precision option is not persisting but the other options are?

Thank you in advance!

-MD

Labels (4)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The precision option expects an integer specifying the number of decimal places to display.  Entering "0.000" means show no decimals.  Try

<option name="precision">3</option>

See https://docs.splunk.com/Documentation/Splunk/9.0.1/Viz/TableFormatsXML#Number_format_rules for more information.

 

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

View solution in original post

MDSplunkNinja
Explorer

This makes total sense.  It is a little misleading however between the UI format option which gives options like 0, 0.0, 0.00, 0.000, 0.0000, and the Source format which requires an integer which when having zero decimal precision is the same setting in both..."0".  An enhancement for the UI to align with the Source editing would probably be a good idea.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You're not wrong.  Go to https://ideas.splunk.com to make your suggestion.

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

richgalloway
SplunkTrust
SplunkTrust

The precision option expects an integer specifying the number of decimal places to display.  Entering "0.000" means show no decimals.  Try

<option name="precision">3</option>

See https://docs.splunk.com/Documentation/Splunk/9.0.1/Viz/TableFormatsXML#Number_format_rules for more information.

 

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Buttercup Games: Further Dashboarding Techniques (Part 4)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

SOC Modernization: How Automation and Splunk SOAR are Shaping the Next-Gen Security ...

Security automation is no longer a luxury but a necessity. Join us to learn how Splunk ES and SOAR empower ...