Hello,mschae16. I have the same problem. I’m using Influxdb, Telegraf and Chronograf and Mqtt (CloudMqtt). My Mqtt receives data from an ESP32 as a String. So, I collect this data using telegraf but with a little change in the [[inputs.mqtt_consumer]] plugin. Here are the changes:
data_format = “value”
data_type = “string”
Due to my data are all strings, I couldn’t save it into Influxdb because Influx expects the data to be a Line protocol. So making the changes I’ve mentioned above, I was able to store data in influx as a string.
But when I try to see data in Chronograf it doesn’t work.
I’m also using Grafana and at first (Query B default configuration) it was the same, I couldn’t see anything in the chart, using the Query B configuration:
Then I made some changes (Query A) and it works.
I’ve provided Query B just as an example of the default query.
This is the query for chronograf:
SELECT mean(“value”) AS “mean_value” FROM “mqttbase”.“autogen”.“mqtt_consumer” WHERE time > :dashboardTime: AND “topic”=‘temperatura’ GROUP BY time(:interval:) FILL(null)
Doesn’t work. I know it is because of my string data but I don’t know how to do the query in this case.
Could you help me, please?
Thank you in advance,=)