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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

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 ...