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 | I am a number, but when you add ‘G’ to me, I go away. What number am I?

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

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...