Selecting specific data to show on Thingspeak graph app

I have recently installed an NCD MegaModem paired with an NCD Temperature sensor for our lab freezers (-80c). I have set the gateway for MQTT transmissions. I can see that my MQTT gateway is transmitting data to mqtt…

….com:1883 since I am getting the following output:

{"channel":{"id":1155233,"name":"baolab","latitude":"0.0","longitude":"0.0","field1":"temperature_celsius","created_at":"2020-09-23T15:38:10Z","updated_at":"2020-09-23T22:07:26Z","last_entry_id":7982},"feeds":[{…

…"created_at":"2020-09-25T17:13:36Z","entry_id":7981,"field1":"{"transmission_count":105,"battery_level":3.06544,"type":39,"node_id":0,"rssi":34,"temperature_celsius":-80.18}"},{"created_at":…

…"2020-09-25T17:13:58Z","entry_id":7982,"field1":"{"transmission_count":107,"battery_level":3.06544,"type":39,"node_id":0,"rssi":31,"temperature_celsius":-80.08}"}]}

My question is…

…:

How can I select/choose to show only temperature_celsius on the graph? Right now I am not getting anything on the graphs.

Field1 name is temperature_celsius.

Thanks a lot!

Answer 1

[Vinod]

I suspect your MQTT gateway is not formatting the data correctly. Why not directly send the MQTT data to mqtt.thingspeak.com instead of relying on an intermediate broker? Here's documentation that can help you send data directly to mqtt.thingspeak.com.