I’m attempting to use the graph visual with SQL Server to show item counts in hourly intervals, but my data appears to have the UTC offset in the wrong direction.
For example, a data point that should be at 21:00 local time is showing up at 07:00 on the graph (original UTC for it is 14:00). I’ve verified everything is in UTC including the row data, DB server, and Grafana server. Both the organization and dashboard time zones are configured as “Local browser time”.
Am I missing a configuration somewhere? Here is my query:
$__timeGroup(j.PickupUtc, $__interval) as time,
sl.Name as metric,
FROM Jobs j LEFT JOIN ServiceLevels sl ON j.ServiceLevelId = sl.Id
WHERE j.dataSourceId = $dataSourceId AND j.PickupUtc BETWEEN $__timeFrom() AND dateadd(hh, 2, $__timeTo())
GROUP BY $__timeGroup(j.PickupUtc, $__interval),
ORDER BY 1