Display table query as multiple time series with legend

  • What Grafana version and what operating system are you using?
    Grafana Cloud vmain-2ef9154

  • What are you trying to achieve?
    I have a postgres query that returns a single table with 3 columns: count, date, and site_name. I want to display this as a time series, where each row is a separate series.

  • How are you trying to achieve it?
    I made a time series panel. I’ve tried a few different transformations but haven’t found one that works. So this image shows how it looks with no transformations.

  • What happened?
    It looks like each row is drawn as an individual point. So on the date 3/14 there are 2 points, representing 2 different sites. That’s good, but I need them to be labeled. The site_name field doesn’t show up at all. The legend just calls them all “count”.

1 Like

You are formatting query result as table, not as timeseries.

1 Like