Missing data with 'last x hours' selection

Grafana
1

Hi there,

I’m using a MySQL table which holds my power consumption in kwh (this table is a result of the calculated average over 5 minutes), the datetime field is of the type ‘datetime’

In the table you can see there is a higher usage, above 2kwh between 8:45 and 9:05am

The selection query is:

SELECT
  UNIX_TIMESTAMP(datetime) as time_sec,
  CurrentUsage as value,
  location as metric
FROM `Power-SUM`
WHERE $__timeFilter(datetime) 
ORDER BY datetime ASC

When viewing ‘today’s’ view I do see the spike, and the rest of the data until the time of the snapshot (10:50)

1598×491 83 KB

However when selecting the ‘last x hours’ , I can see the start of the spike, but not the rest of the data.

1598×486 67.3 KB

I’m sure this has something to do with my timezone (Amsterdam, which is GMT+2 (CET), (but if I change the timezone in the preferences to UTC, it actually shifts the graph backwards with 2 hours, so then suddenly the spike is at 7am)

Any thoughts? :slight_smile:

2

Snip of the SQL table":

555×793 109 KB

(new users are not allowed to post more then 2 pictures in the opening post)

3

note: all reports are showing data upto 9 am (last 12 hours, today so far, last 2 days, this week so far etc)

1599×785 98.2 KB

Only ‘today’s’ report and ‘this week’ are showing data upto 11am