Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SELECT time,
MAX(CASE WHEN channel = 5 THEN to_char(value, '999D9999') else 'NaN' end) as data1,
MAX(CASE WHEN channel = 24 THEN to_char(value, '999999') else 'NaN' end) as data2
FROM
database
WHERE
channel IN (5,24)
GROUP BY
TIME
ORDER BY
TIME