Trailing zeros when 2 decimal places for a number

Grafana Configuration
1

Hello together,

If I define 2 decimal places for a number in the panel and set Unit to Locale, I will not get any trailing zeros if the number does not have a value after the decimal place. Is that a bug and can I solve it?

thanks for help :slight_smile:

2

what is your datasource? and what is the data type of that column in that datasource.
Also can you share a sampling of data

3

I have the following configuration:

Data source is JSON

1234.5

Convert to String with Unit = Local format and Decimal = 2

1.234,5

desired result should be with 0 attached

1.234,50

4

What locale is this?

5

Local format is Germany.

1 Like
6

only probably way is to use jsonata as follows. I cant get it to implement that format

image
image1177×227 18.5 KB

which uses xpath standard
https://www.w3.org/TR/xpath-functions-31/#func-format-number

7

Thanks for the tip. You’re right, I haven’t found a way to integrate the $formatNumber function with the JSONata path. :frowning: