Following query works fine in the workbench:
SELECT now() as "time",
distinct STATE.State_Name_Abbrevation as “metric”, SURVEY_RESULT.Value as “value”
INNER JOIN STATE ON SURVEY_RESULT.ST_ID = STATE.ST_ID
WHERE SURVEY_RESULT.Topic = ‘BMI Categories’ AND SURVEY_RESULT.Response = ‘Obese (BMI 30.0 - 99.8)’ AND SURVEY_RESULT.Year = ‘2018’
GROUP BY SURVEY_RESULT.Year, STATE.State_Name_Abbrevation, SURVEY_RESULT.Topic, SURVEY_RESULT.Response;
but gives me an error 1064 (syntax) in Grafana. I’d appreciate any ideas. Working on this for hours now…
My goal is a bar chart with values to compare.