Updating stat value depending on time range giving in grafana dashboard

[lachg258]

Hello,
So at the moment I have a stat panel that is pulling a large range of data from a single column in a MYSQL database. Using the “calculation” option in grafana I have selected “Total” which is providing a total combined price of all the values from this MYSQL table. I was wondering is it possible to have this stat panel perform the total calculation on the data selected from the time frame in the dashboard. As depicted in the image below I want the total combined prices from any values pulled in the last 3 hours (where instead it is just providing a total of all the values in the MYSQL database).

[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