Hi I’m very new to InfluxDB and Grafana and I try to have a dropdown filter selection.
I’m able to create the normal filter but when I try to filter the second dropdown values base on the selection in the first dropdown, I can’t make it work.
I have one Tag called “room” which is the selection where I want the values filtered based on the first selection which is “level” I created a variable called q_level.
This is basically house, level , room.
when I select the house in the first dropdown I want it to show only the levels for that house and when I select the level I only want it to show the rooms in that house.
I tried a number of combunation but some how its not working
import “influxdata/influxdb/schema”
schema.tagValues(bucket: “myhouse”, tag: “room”)
|> distinct(column: “_value”)
|> filter(fn: (r) => r._value == “${q_house}”) //where q_house is the variable for house
any help would be greatly appreciated.
