MS-SQL: Visualize multiple series in Time Series Graph panel with multi-value variable in query statement?

  • What Grafana version and what operating system are you using?
    v.9.3.2

  • What are you trying to achieve?
    I want to visualize multiple series in a Time Series graph panel with multi-value variable in my query statment.
    For example on play.grafana.com:


    You can see for every web-server a series.

  • How are you trying to achieve it?
    I tried different solutions, but it not work with multi-value variable (The multi-value variable is to set the different series)
    My first solution:
    Write multiple query statements for every webserver (no multi-value variable)


    Then it works, but without multi-value variable. It’s static…

When i create the one query with use of multi-value variable, i get only one series because i retrieve only one dataset.

  • What did you expect to happen?
    I want a vizualitation like this one Edit panel - Grafana

  • Can you copy/paste the configuration(s) that you are having problems with?
    Check picture.

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

  • Did you follow any online instructions? If so, what is the URL?
    I didn’t find any solution…

Thank you so much! It work’s! Didn’t know that transformation opportunity ! :slight_smile:

1 Like