Dealing with text fields

I have a metrics whose field contains text of a status (standby, playing, etc) coming from a home automation system. Using Grafana I’d like to be able to see how much time it has been in each status, is there a way to do that?

I don’t have a ton of control over the structure of the data to turn the field into a numeric and the status into a tag - that seems like the easier way to do it.