What Grafana version and what operating system are you using? Grafana v9.5.0-cloud.5 What are you trying to achieve? I have various dashboards for the data coming from influxdb. I want to create the dropdown menu for the different tags in my influxdata source, so that i can select one or two …

Continuing with my example, if we want to use two tag values (e.g. 301 and 303) in the same query, replace this line: |> filter(fn: (r) => r["MyEquipNumber"] == "${GeneratorNumber}") with this: |> filter(fn: (r) => contains(value: r["MyEquipNumber"], set: ${GeneratorNumber:json})) However, y…

Welcome @leonardoselex to the Grafana forum. Here is how I use tag values in my dashboard using this : [image] [image] [image]

Thank you much for the reply. Yes for example i got the dropdown menu suposse of my tag “projectnumber”, but i select any one of them in the dropdown menu i still see the data from all the projectnumber in the dashboards. How do i solve this? thank you much again

Continuing with my previous example, the Flux query gets modified in Grafana using ${tag_name} like this: from(bucket: "Mydata") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_field"] == "GeneratorTemperature") |> filter(fn: (r) => r["MyEquipNumber"] == "${G…

thank you very very much. This works when i select item in a tag but the thing when i select select two poject number in a tag called projectnumber it says nodata. How can we solve this? Thank you much in advance

thank you yes it works. May be there was bit problem with loading the dashboard as soon as i configure the variables i made in the current dashboard. Other dashboard without the use of the variable are loaded fine but with this its really slow. Is there any effect of it ? any idea?

Apparently contains() can cause performance / speed issues. Maybe check this out and try it and report back here if you get it to work better.

contains() function is way to slow! If performance is an Issue, I recommend avoiding it at all costs. what I do, is I build entirely the “filter” piece of the code, using another chained variable that makes another query using Variable1, then with reduce function and some trickery I reduce all my “…

Just curious as now this post seems more fitting for the InfluXDB category. Please let me know if it OK to move it there…? :slight_smile:

Dropdown menu in dashboards where data are coming from influxdb

Grafana InfluxDB

grant2 May 15, 2023, 9:17pm 11

Yes, InfluxDB is the better category for this post.

I have adjusted:

1 Like

Topic		Replies	Views
Dropdown variable from InfluxQL tags InfluxDB	1	277	January 21, 2024
Multi dropdown variable, beginner question Dashboards influxdb	1	861	June 29, 2023
Dropdown menu in dashboards with "variables" where data are coming from InfluxDB v2.7.5 / InfluxQL InfluxDB	4	2388	March 24, 2024
Using Influx tags as variables in Grafana Grafana	3	6103	December 23, 2020
Creating Flux variable on grafana 10 dashboard Grafana templating	2	170	March 26, 2024

Dropdown menu in dashboards where data are coming from influxdb

Related topics