Updating stat value depending on time range giving in grafana dashboard

[wlargou]

Hi,

Please check this thread :

Graph Time Range Filter selection doesn't work with MYSQL

I ran into the same problem. I believe that if you expand the time range(backwards) you will start seeing data. [OutOrRange] Expanded to the whole day. [TheWholeDay] The data is there, but the time filter is cutting it off based on the time zone, here is it showing all of the data. [AllTheData] The problem is that the Query builder has: date AS “time”, … $__timeFilter(date) data AS “time” is getting in the data in UTC. The $__timeFilter(data) Translates to: FROM_UNIXTIME(), which …

You need to use the $_timefilter in your query to restrict the values.

Hope it helps.

Good Luck