Multiple selection from list

Grafana Configuration
1

  • What Grafana version and what operating system are you using?
    Grafana v11.0.0

  • What are you trying to achieve?
    I would like to select multiple values from list and display all of them with trend visualization

  • How are you trying to achieve it?
    Data source: infinity (plugin)
    Type: JSON
    Parser: UQL
    Source: Inline
    format: data Frame

I added a variable names Rank from the JSON (i.e 0,1,2)
I also used Transform data to change the format of “time” and “hight” to number

  • What happened?
    I can only view one selection at a time

  • What did you expect to happen?
    be able to select multiple selection from list

  • Can you copy/paste the configuration(s) that you are having problems with?
    UQL query:
    parse-json
    jsonata “People[Name = ‘Alex’ and number = 1 and rank in $Rank][ ].data[ ]”

  • 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 following this link:
    Simple JSON API & Dashboard Variables don't appear to work - #13 by yosiasz

3 
{
   "People":[
      {
         "Name":"Alex",
         "number":1,
         "rank":0,
         "data":[
            {
               "time":"0",
               "hight":"60"
            },
            {
               "time":"1",
               "hight":"62"
            },
            {
               "time":"2",
               "hight":"65"
            },
            {
               "time":"3",
               "hight":"61"
            },
            {
               "time":"4",
               "hight":"63"
            },
            {
               "time":"5",
               "hight":"62"
            },
            {
               "time":"6",
               "hight":"68"
            },
            {
               "time":"7",
               "hight":"68"
            },
            {
               "time":"8",
               "hight":"63"
            },
            {
               "time":"9",
               "hight":"62"
            },
            {
               "time":"10",
               "hight":"67"
            },
            {
               "time":"11",
               "hight":"64"
            },
            {
               "time":"12",
               "hight":"63"
            },
            {
               "time":"13",
               "hight":"62"
            },
            {
               "time":"14",
               "hight":"67"
            },
            {
               "time":"15",
               "hight":"67"
            }
         ]
      },
      {
         "Name":"Alex",
         "number":1,
         "rank":1,
         "data":[
            {
               "time":"0",
               "hight":"62"
            },
            {
               "time":"1",
               "hight":"62"
            },
            {
               "time":"2",
               "hight":"65"
            },
            {
               "time":"3",
               "hight":"61"
            },
            {
               "time":"4",
               "hight":"63"
            },
            {
               "time":"5",
               "hight":"62"
            },
            {
               "time":"6",
               "hight":"68"
            },
            {
               "time":"7",
               "hight":"68"
            },
            {
               "time":"8",
               "hight":"63"
            },
            {
               "time":"9",
               "hight":"62"
            },
            {
               "time":"10",
               "hight":"67"
            },
            {
               "time":"11",
               "hight":"64"
            },
            {
               "time":"12",
               "hight":"63"
            },
            {
               "time":"13",
               "hight":"62"
            },
            {
               "time":"14",
               "hight":"67"
            },
            {
               "time":"15",
               "hight":"67"
            }
         ]
      },
      {
         "Name":"Alex",
         "number":1,
         "rank":2,
         "data":[
            {
               "time":"0",
               "hight":"67"
            },
            {
               "time":"1",
               "hight":"68"
            },
            {
               "time":"2",
               "hight":"69"
            },
            {
               "time":"3",
               "hight":"70"
            },
            {
               "time":"4",
               "hight":"65"
            },
            {
               "time":"5",
               "hight":"66"
            },
            {
               "time":"6",
               "hight":"68"
            },
            {
               "time":"7",
               "hight":"67"
            },
            {
               "time":"8",
               "hight":"67"
            },
            {
               "time":"9",
               "hight":"67"
            },
            {
               "time":"10",
               "hight":"69"
            },
            {
               "time":"11",
               "hight":"71"
            },
            {
               "time":"12",
               "hight":"79"
            },
            {
               "time":"13",
               "hight":"76"
            },
            {
               "time":"14",
               "hight":"78"
            },
            {
               "time":"15",
               "hight":"78"
            }
         ]
      }
   ]
}
4

can you please click and show us screen capture of the bottom section of the rank variable?

5

variable1

I checked the multi-value.

1 Like
6

so does that solve it?

7

No.
When parsing with:

parse-json
jsonata “People[Name = ‘Alex’ and number = 1 and rank in $Rank][ ].data[ ]”

I get result of:

image
image988×421 29.8 KB

8

always use this tool for your jonsata part

https://try.jsonata.org/QjN9Xz5sV

9

Thanks, but still, I can’t visualize multiple selections

variable4
variable4711×345 18.4 KB

variable5
variable5715×340 12.4 KB

10

did you read the jsonata documentation ?

https://grafana.github.io/grafana-infinity-datasource/docs/filters