SQL query used in Grafana to get temperature and humidity form MySQL server and computer dew point and heat index and display in panel.

query.sql

SELECT
  dt_created AS "time",
  temp AS "Temperature",
  humidity AS "Humidity",
  (temp - ((100 - humidity)/5)) AS "Dew Point",
  ((temp* 1.8) + 32) AS temp_f,  
(((-42.379 + 2.04901523*@temp_f + 10.14333127*humidity - .22475541*@temp_f*humidity - .00683783*@temp_f*@temp_f - .05481717*humidity*humidity + .00122874*@temp_f*@temp_f*humidity + .00085282*@temp_f*humidity*humidity - .00000199*@temp_f*@temp_f*humidity*humidity) - 32)*.5556) 
AS "Feels Like" 
FROM particle_photon
ORDER BY dt_created;