Grafana Currency

Grafana
,
1

Hello community,

Is there a way to display the currency to the right of the number with Grafana v11.1.0 in a table and gauge format?

image
image887×261 25.7 KB
2

what would it look like ?

637€K or 637K€ or 637K €

3

like this 637,24K €

4

that looks very strange value
637,24K €

5

Sorry, I meant either 637.24 € or 637K €

1 Like
6

what is your data source? mysql, mssql?
what is the raw value of this number in your database or db

7

Yes,mssql ,It works correctly with SQL, but in Grafana, it’s not working.
With which unit did you test it, please?

select
FORMAT(SUM(MCA.montant) , ‘C’, ‘fr-fr’)
FROM ChiffreA MCA

The unit is Locale format

image

1 Like
8

what is the raw value of this number in your database or db

play around with this sql statements

select 637240, 
cast(637240 as decimal(10,2)), 
FORMAT(637240, 'C', 'fr-fr') 'German', 
FORMAT(637240, '0.00 "€"', 'hr-HR');

It’s really not a grafana issue but more of an mssql issue

image
image718×610 31 KB