For quite some time, I have been using Grafana 5.2.2 together with MS SQL with great success. Today I decided it was time to do an upgrade, but for some of my dashboards it seems to be not that straight forward.
I’m using this query to fetch data for one of my dashboards.
SELECT $__timeGroup(DATEOUTLINE, '24h', 0) as time, case when SHIFT = 1 then 'Day 06:00 - 14:00' when SHIFT = 2 then 'Evening 14:00 - 22:00' when SHIFT = 3 then 'Night 22:00 - 06:00' else 'UNDEFINED' end as metric, count(DATEOUTLINE) FROM [AnoHistory].[dbo].[RPT_PRODHEADER] WHERE $__timeFilter(DATEOUTLINE) GROUP BY $__timeGroup(DATEOUTLINE, '24h'), SHIFT
Fields from database used in query is formatted:
DATEOUTLINE is nvarchar in format YYYY/MM/DD
SHIFT is nvarchar in format N where N holds value ‘1’ ‘2’ og ‘3’
As said, thats working great in version 5.2.2, but from version 5.3.0 it’s not working anymore. The query returns a “No data points” in the graph window. I have studied the 5.3.0 changelog, and there seems to have been made some improvements and / or addition to the $__timeGroup macro, but I can’t figure out, if that means I have to do my query another way?
Any help really appreciated.
Best regards Ole