Dashboards & Visualizations

Is it possible to change the thousand separator and decimal separator according to European conventions (e.g. 10.000,234)?

JacobPN
Path Finder

Hi there,

Is there a way to change decimal and the thousand separate to European conventions?
For example, I would like the default to be : 10.000,234 (instead of 10,000.234)
Is this possible without converting numeric values to strings?
It would like this to work in particular for dashboards.

Thanks for your help

strive
Influencer

Check this

https://answers.splunk.com/answers/42814/decimal-how-to-use-vs.html

Also, its worth checking fieldformat command. It wont change underlying value hence it is good for charting purposes.

https://docs.splunk.com/Documentation/Splunk/6.5.3/SearchReference/Fieldformat

0 Karma

JacobPN
Path Finder

Thanks for your help. However, unless I'm missing something, it seems that the methods described there output strings. For example:

... | fieldformat number = replace(replace(replace(number,"\.","#"),",","."),"#",",")

outputs the correct format, but it will be of string type. If I wrap the right-hand side in tonumber() it does not output anything (null), probably because it does not recognize the number format...

-- Edit --
The example above only works for replacing the . (dot) by a, (comma). I think because the default thousands separators (comma's) are added afterwards by splunk.

0 Karma
Get Updates on the Splunk Community!

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...