How do I make a dashboard variable query for JSON Datasource?

1

How do I make a dashboard variable from query type for the JSON Datasource?

I don’t know the syntax of the query, and there’s no documentation about it.

Thanks,

2

use the query inspector on your dashboard to find more about the data coming from your different data sources

3

I saw the query Inspector and the response I got was something like this:

“response”: [{
“columns”: [
{
“text”: “temp”,
“type”: “float”
},
{
“text”: “accelx”,
“type”: “float”
},
{
“text”: “accely”,
“type”: “float”
},
{
“text”: “id”,
“type”: “integer”
}
],
“rows”: [
[
25.9,
-1.0058594,
0.017578125,
0
],
[
26.0,
-1.0117188,
0.013671875,
1
]
],
“type”: “table”
}
]

How do I create an ‘id’ variable from query type with this example? I’m using JSON DATASOURCE