Timeline of status using mysql as source

Hello all,

I’m having a problem with the time series panel and my mysql data, here’s the recap:

  • What Grafana version and what operating system are you using?
    v8.1.3 on Docker

  • What are you trying to achieve?
    I’m trying to get something like this:

  • How are you trying to achieve it?
    To be honest, I’m not sure where to begin. I’ve tried vartious settings, but I can’t figure it out.

  • What happened?
    Basically, I used a state timeline panel, using mysql as the source, but I’m stuck here. I can put a start time, but no end time.

  • What did you expect to happen?
    I expected to be able to put some kind of title on each row, which would be the id of the job. Then, I was expecting to have some kind of way to put a start time and end time. Based on the status of the job, I was expecting to be able to color the timeline matching the status (success or fail). The periods of time where nothing happens in-between executions would be greyed out.

  • Can you copy/paste the configuration(s) that you are having problems with?
    I haven’t done much, so it wouldn’t be any use. Here’s a screenshot of my DB, and the fields I was planning to use:

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?
    I tried to use this, but I can’t really figure out how it could help me in my situation

Thank you for your help !

1 Like