Grafana table interprets keyword as number

[tle1]

Hi

I am using a table panel to display json data from elasticsearch, and especially some git commits sha.

The thing is when the commit is something like 97382e7, grafana thinks it is a scientific number and display 973820000000 instead of the keyword.

Is there a way to tell grafana to not interpret the string?

[wlargou]

Hi,

Did you try and set the field as string :

Hope it helps.

Good Luck

[tle1]

Thanks for you reply, yes I did but unfortunately it does not work

[wlargou]

Hi,

Can you screenshot your table data structure.

Thanks

[tle1]

Hi,

Here is a sample example (elasticsearch database):

{
    "events": {
        "cpu-cycles": 965235055319,
        "duration_time": 1200927092174
    },
    "date": "2020/01/28 12:13:20",
    "commit": {
        "sha": "51475e7",
        "message": "Use SIMD instruction to accelerate GA"
    },
    "config": "xgol",
    "subconfig": "move",
    "sample": "sample_2",
    "metrics_type": "gprof",
    "tags": [
        "test"
    ]
}

So the commit will be displayed 514750000000. If the “e7” is inside, like 123e7455, Grafana shows “infinite” sign: