MQTT dashboard JSON transformation

[summerseasun]

Suppose you have this messagge as resutl from a subscription from “device/status”:

{
    "id": 0,
    "source": "WS_in",
    "output": false,
    "temperature": {
        "tC": 49.0,
        "tF": 120.1
    }
}

Then from dashboard if I set the subscription topic to “#” and go to Query Inspector and see the data incoming:

My questions are:

1. why if I set the subscription topic to device/status no data are shown at all?
2. how could I get the temperature.tC vaule? I’ve tried this transformation without success

[sowdenraymond]

@summerseasun

how could I get the temperature.tC vaule? I’ve tried this transformation without success

try with the format of auto

[summerseasun]

Thanks for your reply, I’m reading the documentation but cannot find anything related: Query and transform data | Grafana documentation

Can you please explain what you mean with “the format of auto”?

[sowdenraymond]

[summerseasun]

Thank you very much that’s it!