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!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...