Hi,
i’m playing around with grafana atm and i observed some strange behavour.
I aggregate some timeline data in an mssql table.
so there is a timestamp, a metric and a value.
When displaying in a graph panel the last two hours display no points on the graph, but the scaling of the graph is correct just empty for these two hours. as soon as i zoom out via double click or the zoom - Button the graph shows the complete set of data. this happens for all the quick time range settings “last x hours” the only settings which displays correct seems to be “today, this week, this month, this year”. “today so far” again doen’t display the last 2 hours.
has anyone experienced this?
I trieds several select variations, converting datetime values to utc by subtracting 2 hours but the problem seems to be persistant.
my query looks like this:
SELECT
dateadd(HOUR, -2, timestamp) as time
,[server] as metric
,sum([queuelength])
FROM [sometable]
WHERE $__timeFilter(timestamp)
group by server, timestamp
order by timestamp
I am having a similar problem, however, my data is zoomed in. In more detials, lets say that last data point i have is at 14h00. When i apply any time range(for example: last 2h, 3hr, today so far))The graph shows all previous data from 13h00 and backwards and does not include the interval 13h00-14h00. However, if i zoom out(double click or ctrl Z) i can see the 13h00-14h00 range and it functioning well. I am not sure why this is happening. UTC time format is write on server, PC and Grafana
Yes, triple checked it. The timestamp is right(local time lisbon, Portugal) and the time on the dashboard crosponds to it. I have posted my issue in detials here: "Absolute Time Range" Issue in Grafana Dashboards
The timestamp is right in the data base. It is UTC and I have cheked it again. And on the dashboard, as well. It seems that the last how data is hidden into the future. Only when i zoom out it appears.
