Display string data in a ePictPanel

1

Hello everybody, i’m a student, newbie on grafana, I don’t know if it is the right channel.

I need help please, to display the result of my second query (B) which is actually the name of the device which is parked at the loading dock. It actually displays N/A (right next to the green button). I don’t know how to change it.

Should I give you any other informations so that you can help me?
If it is possible, can I do it by adding device to the select of my first query ?

Capture.PNG
Capture.PNG3789×1903 744 KB

2

Hello,

it’s because you selected “Format as: Table”.
Try with “Time series”, your query should look like this:

SELECT
 start_parking_time as time,
  (CASE etc...)  as value,
  'state' as metric
FROM parking
order by start_parking_time desc