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.


Expanded to the whole day.

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.

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 returns the time in local time.

So instead I had to switch to editing the SQL directly and use:
$__time(date),

$__time also returns local time and this keeps the graph times, and filter times consistent.