InfluxDB + Grafana: State Timeline with entities of typ "String"

Configuration
1

Hi Experts,
is it possible to store entities from Home Assistant that store a state as a string (e.g. device_tracker, iphone ssid or connection_type etc.) also in influxdb as a string?
When I want to create a state timeline in Grafana with such a sensor, I always see only numbers, but not the actual states. With binary_sensors this is no problem, because I can resolve 0 and 1 via value mapping. But if I want to store when my phone was connected to which wifi network, then this is not possible anymore (is it???)
Is there somewhere to set that this kind of data is saved as text and not as a number by Home Assistant or interpreted by Grafana?

Best thanks in advance for any hint!

Best regards
Rado

Translated with DeepL

2

did you ever get this answered?

3

Hi,
No, but after a while I found a way. You have to query the “state” field and not the “value” field. The strings are in the “state” field.

Regards
Rado