Setup: Windows 10, 64bit MqSQL DB OH2.2 Grafana 4.6.3 Dear all In OH I get for several items ON or OFF values which are stored in MySQL DB. Using the native OH charts these values will be transformed to 1 or 0 and can be displayed in OH charts. Use case: room temperatur, chart shows: current …

A bit of ANSI-SQL is all you need SELECT FLOOR(UNIX_TIMESTAMP(time)) as time_sec, CASE WHEN value = 'ON' THEN 1 ELSE 0 END as value, 'Heiz_DG_Zi1_Stellwert' as metric FROM openhab.item266 WHERE $__timeFilter(time) ORDER BY time ASC I find the Discrete panel works well for showing this type of valu…