With the flux query shown above, I can get all query result, which is the organisation name list in the Influxdb explorer, while I can only get tiny part of the query result in grafana as variable. In other words, I can only get a small portion of the organisation name list in the dropdown list.
Is there any way that I can show all the result in the dropdown list in the dashboard?
Is there any way that I can show all the result in the dropdown llst?
I think you are asking if the size of the dropdown can be expanded? In my example below, a vertical scroll bar appears because the list of Part Numbers is quite long. AFAIK, the size of the dropdown box is not adjustable in Grafana.
Hi mate @grant2
In my case, the number of the organisation names are more than 6000, but only a small portion (around 500 records) of those 6000 organisation names are displayed in the dropdown list in the Grafana dashboard. With the exact same flux query, I can get full result in InfluxDB’s built-in data explore.
So I am guessing is that there are only limited number of rows that can be shown in the dropdown list in Grafana dashboard or is there any configuration that I can change to display more rows in the dropdown list in Grafana dashboard
thank you for your response mate
@manurodgers If you have 6000 choices and only ~500 are being displayed in the dropdown list, then I would venture to guess that Grafana’s web builder (or whatever it’s called) has a fixed limit on how many choices can be displayed (unlike the Influx Data Explorer, which apparently has no such limit).
This question is best answered by a Grafana software engineer.
Thank you for your quick response mate
