I am trying to setup Bar Gauge and it’s working with my query but the data displayed in Bar Gauge is not calculating correctly. Here is is my select statement aside from my entire query, i am basically just taking “duration” which is an integer value which is a total number of seconds , then i’m converting seconds to hours as a decimal value.
SELECT object_name as metric, cast(SUM(duration)/(60.00*60) as decimal(6, 2)) as value
this is what MS SQL comes back with SQL Server management studio query, which is what i expect.
> +--------------+-------------------+
> | metric | value |
> +--------------+-------------------+
> | Object1 | 0.63 |
> | Object2 | 0.02 |
> | Object3 | 1.83 |
> | Object4 | 0.35 |
> | Object5 | 0.43 |
> | Object6 | 2.57 |
> | Object7 | 0.43 |
> | Object8 | 0.32 |
> | Object9 | 15.61 |
> | Object10 | 20.10 |
> | Object11 | 0.26 |
> | Object12 | 1.90 |
> | Object13 | 0.49 |
> | Object14 | 0.21 |
> | Object15 | 0.39 |
> | Object16 | 15.03 |
> +--------------+-------------------+
when i then copy the query over into Grafana, it has no issues but comes back with totally different values ?? see screenshot, so i can’t figure out why i’m getting the right values via MS SQL management studio query, but Grafana is different. I thought if i had my query working in MS SQL i could just move it over into Grafana.
