Display Data From Named Query (MySQL) On a Time series Chart

Ignition
21

Things you should have learned from this thread:

  • Time Series charts require a time series column!
  • The time series column has to be a DateTime type, not a string.
  • Therefore the SQL query must return a DateTime, not a string.
  • When someone suggests using
    SELECT FLOOR(t_stamp / 3600000) * 3600000 AS Hour
    and explains that "This will preserve the t_stamp as a DateTime type."
    then converting it to
    SELECT DATE_FORMAT(t_stamp, '%Y-%m-%d %H:00:00') AS Hour
    isn't really taking their advice.

Have fun!

3 Likes
22

thank you, Noted sir