Gauge Indicator not Shown

1

Hi,
I have created a Singlestat using Grafana. I am using Mysql Database. I am able to fetch values form DB. The issue is I don’t get the gauge Indicator. I get the outer thin threshold indicator. But not the gauge one. Request you to provide inputs. I would like to compare data for different years.

02
023104×1844 491 KB

Also in edit panel, Under metrics tab, I have chosen Table as Format As Option. Is the issue because of this? Suggest me some inputs.

59
593104×1844 452 KB

2

Make sure your query returns a number and not a string, can you show output from query inspector?

3

Hi,
Thanks for the response. Please find the query inspector values.

52
523104×1844 611 KB

4

Hi,
I checked my column. It was string datatype. So I created a column with int datatype and selected it. Now I am getting the gauge indicator. Thank you for the input. My issue is fixed.

00
003104×1844 530 KB