Bar Gauge Numeric Fields - Expose the ID (text) as number

Grafana Elasticsearch
1

Hi everyone.

I’m creating the bar gauge dash to show the average values by desc sorting. There is something really weird happening… When I choose the “Numeric Fields” in “Fields”, the average elapsed time of each document is presented, as expected, but the IDs are presented as value numbers too:

My Configuration and the data table result (using the $__cell_0 in Display Name)

configuration_bargauge_data
configuration_bargauge_data1687×876 52 KB

The bar gauge results:
bargauge_problem|690x194 !

Note that the red box with the ID values as Numeric fields (maped as text) and the blue box with the average results.

Is someone experiencing the same problem?

2

Hello @brunofds! You can use Query Inspector to see if IDs are coming from Elasticsearch as strings or numeric values. If they are string, I would open issue on github. If they come as number, then Grafana is displaying it correctly.

What you can do to fix your Bar gauge is to use Transformation and hide all id fields and show only time.

image
image1776×408 23.5 KB

3

hi @brunofds ，do you resolve the problem ?