Allow setting a default number format

[jonahgreenthal]

Redash supports a default date format and a default time format (in Settings > General). It would be good to support default number formats too.

My use case: The overwhelming majority of numbers I work with are integers, and I would prefer that they be formatted without thousands separators. For example, I want 12345. However, Redash defaults to formatting with commas as thousands and showing two decimal places (e.g., 12,345.00). I'd love to change the setting all at once rather than editing the visualization for every query, column-by-column.

[aesanchez]

Where you able to solve this? I'm interested in the same

[jgreenthal]

No — this is a feature request.

[ekonoval]

Same for me, I'm using it mostly to work with IDs, so it's very inconvenient to change number format all the time

[eradman]

This feature is missing in the UI, but it can bet set in the database

UPDATE organizations
SET settings = jsonb_set(settings::jsonb, '{settings,float_format}', '"0.0"', true);
UPDATE organizations
SET settings = jsonb_set(settings::jsonb, '{settings,integer_format}', '"0"', true);

SELECT jsonb_pretty(settings::jsonb)
FROM organizations;

[aesanchez]

Interesting, I'll give it a try