kks
1
Hello,
“1,000.5 hours” is displayed in Germany as: “1.000,5 h”
It’s absolutely perfectly solved in the counter area:
But I can neither format the character for the thousand point and decimal point in the tables
nor in the chart:
Can you please extend the function so that you can also configure the character for the thousand point as well as the decimal point in the tables and charts? And the suffix (here e.g. " h" or " €").
Thank you!
kks
2
According to Wikipedia more counties are using the decimal comma (green) than the decimal point (blue), so this is not only a german but an international issue.
jcohoon
3
As a terrible workaround until more formatting options are available, could you do some kind of string replacement:
SELECT replace(replace(replace(replace(1000.5::text, '.', 'd'), ',', 'c'), 'd', ','), 'c', '.') AS number
I’m not sure you can actually accommodate the thousands separators this way though given that they’re presumably added by Redash at the point of display, but probably some other kind of string manipulation could insert them.
Besides being generally ridiculous, this would be no good if you’re trying to create a visualization from the values.
