How can I format a numerical value in a single value panel with thousand-separators?

[mathiasrichter]

I would like to display financial values in a dashboard. In order to do this sensibly, I would need to have a number like 300000 display with thousand-separators, ie. 300'000. How can I control the format in the single value panel to achieve this?

[somesoni2]

Add following to end your search

Your base search for single value, say the field name is count | fieldformat count=tostring(count, "commas")

OR

Your base search for single value, say the field name is count | eval count=tostring(count, "commas")