In Germany there are always Irritation here when you see a dot in the number, the dot is to separate between one hundred and the thousand place and therefore the number is much too big.
It shows 1071 MWh instead of 1071 kWh. Until a few days ago, when we were under a thousand, the world was still in order
Is there a way to replace the dot with a comma?
what do you get when you set the following
I do not have the setting at this point Standard options Unit.
Do I have to preset this somewhere else? I am unfortunately a complete beginner in grafana
what version of grafana are you on? and does influxql have way of formatting those numbers?
THX ebabeshko
Is there still a possibility to add a text to the number? so that you can see the unit kWh again. I have written the unit in the Titel, but it doesn’t look as professional as before.
As of now it is not possible, although such feature was requested long time ago:
opened 02:14PM - 27 Mar 19 UTC
type/feature-request
area/units
Currently in order to add commas or periods to large numbers you have to select … "locale" as a format but that will disallow the use of any units you might want to display.
**What would you like to be added**:
Could you change the option for long format numbers to be a choice between none, locale, and short, but still allow a unit selection to be made.
**Why is this needed**:
This would allow the user to choose both the format of the numbers being displayed as well as the specific unit. An example would be if I wanted to display the number of Dollars in my bank account: I could use CurrencyUSD and I would see **$123M** but if I wanted to see the number down to the hundreds or even cents I would have to apply a decimal of 6 or 8 (which would change as I spent or earned money) to see **$123.45678900M** this is not very easy to visually decipher so the option to display currencyUSD + locale would give me **$123,456,789.00** this give clear visual separation which is needed on dashboards where the intended audience is going to glance at or view from a distance without being able to study the number closely.
This would apply to any number unit that currently default to short.
This would also fix an issue with currencyBTC which has up to 8 decimals and the difference between viewing **฿1.035K** and **฿1,035** is quite large if you miss the `K` or misinterpret the difference between a `,` and a `.`
opened 09:57AM - 04 Mar 16 UTC
type/feature-request
area/panel/graph
In Europe, South America and Russia the [decimal mark](https://en.wikipedia.org/… wiki/Decimal_mark) is a _comma_ and the thousand separator is a _point_. Let the user choose to format numbers in this way will make graphs a lot more readable for non US readers.
The same for date formatting.
#3003
#3529
#1459
1 Like
pooh
May 14, 2024, 8:11am
8
In my opinion Grafana should simply follow the machine’s locale settings, as
decimal and thousands symbols
date format DD/MM/YYYY, MM/DD/YYYY, YYYY/MM/DD
time format 12h/24h
possibly even currency symbol too
Antony.
1 Like
