If you set the variables REDASH_INTEGER_FORMAT="0 0" and REDASH_FLOAT_FORMAT="0 0.00", it does not work.

[X-Crux]

I need to use the " " character for thousands separators throughout Redash, instead of ",". I'm setting the variables:

• REDASH_INTEGER_FORMAT="0 0"
• REDASH_FLOAT_FORMAT="0 0.00"

But it don't work. I tried changing the settings field in the organizations table.
If I change the settings field in the organizations table, the numbers are displayed without any separators at all. Apparently, somewhere in the code, all the " " characters are being removed from the numbers.

How can I make separators using the " " character?

[eran132]

The issue is real, but the cause isn't what it looks like — Redash isn't stripping spaces. The root cause is numeral.js semantics, the formatter Redash uses.

In numeral.js, , and . in format strings are locale-aware markers ("insert the locale's thousands/decimal separator here"), not literal characters. The actual chars come from numeral.localeData().delimiters. With the default en locale, delimiters is {thousands: ",", decimal: "."}, so "0,0" formats as 1,234,567. The format string "0 0" isn't a valid numeral pattern — the space is silently dropped, so no grouping is applied at all.

Verified locally with numeral.js 2.0.6 (the version pinned in package.json):

numeral(1234567).format("0,0")    => "1,234,567"
numeral(1234567).format("0 0")    => "1234567"   ← matches what the reporter saw
numeral(1234567).format("0 0.00") => "1234567.89"

There's currently no Redash setting that overrides numeral's locale or its delimiters, so a space (or NBSP, or apostrophe — Swiss style) thousands separator simply isn't reachable today.

A small fix: expose REDASH_THOUSANDS_SEPARATOR and REDASH_DECIMAL_SEPARATOR env vars (defaults "," / "." to preserve current behavior) and apply them once at frontend init via numeral.localeData().delimiters = {...}. Verified the override mechanism works:

numeral.localeData().delimiters.thousands = " ";
numeral(1234567).format("0,0")    => "1 234 567"

numeral.localeData().delimiters.decimal = ",";
numeral(1234567.89).format("0,0.00") => "1 234 567,89"

This single mechanism covers full continental-European number formatting, not only the space-separator case.

@arikfr / @eradman — would you accept a small PR adding those two env vars (plus optional org-settings counterparts), wired through number_format_config() and applied to numeral at app init? Happy to take it on if so.

[arikfr]

Thank you for the elaborate explanation @eran132! Two thoughts:

1. Should this be org config, that can be set via the UI as well?
2. Should we let the user set the thousands/decimal separator or maybe instead let them set the locale? Maybe both options?

Either way, open for a PR addressing this 🙏