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

Grafana MSSQL
1

  • 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:

    image
    image1040Ă—497 49.9 KB

    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)

    image
    image1509Ă—1112 74.9 KB

    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…

2

Welcome,

Do you not have the server name that maps to webserver field? in your example you have 645.

If you use the following transformation

image

Then you do not need multiple queries. And obviously multi queries would not scale if you have more servers

1 Like
3

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

1 Like