How to format number in a Grafana table?

Question

I'm displaying some data in a Grafana table and one of the columns is a number between 1 and 999999. I want it to be always displayed with six digits, with leading zeros, e.g. 012345. How can I do this?

Update: My data source is ElasticSearch.

Depending on your datasource, this might be much easier to implement in the query than in Grafana — dnnshssm, Dec 02 '22 at 10:53

score -1 · Answer 1 · answered Dec 07 '22 at 16:02

-1

A similar issue was discussed here, this can be resolved by adding a field override for the field, with “Unit” as “Misc → String”. You can follow this link for configuring field overrides

answered Dec 07 '22 at 16:02

Kranthiveer Dontineni

1,056
1
10

That's a different problem. – Antonis Christofides Dec 09 '22 at 10:00
@AntonisChristofides If the data source is already sending data with leading zeros. you can use a string variable at grafana end to display them in the table. Sorry for not explaining this clearly in the previous post. – Kranthiveer Dontineni Dec 09 '22 at 10:28
The value is a number. An integer. – Antonis Christofides Dec 09 '22 at 12:16

How to format number in a Grafana table?

1 Answers1