- What Grafana version and what operating system are you using?
grafana-10.1.4-1.x86_64
- What are you trying to achieve?
Using an external Source with “Description”,“host”,“interface” to use as Dashboard Variables . The User should select the Description, the InfluxDB Query needs “host” and “interface” .
I got this working with 3 Postgres SQL Display variable queries, like .
query0 = select description from table
myinterface = select interface from table where description like ‘$query0’
myhost = select host from table where description like ‘$query0’
So if the user Select the Description i could use the variables myhost,myinterface in the flux query.
All good, but now we are forced to gather this info from a http CSV …
- How are you trying to achieve it?
Using Infinity CSV Plugin for Casaded Dashboard Varialbes .
- What happened?
Simple do not get it working .
Not found a way to filter on another column then the one used for the variable
Tried UQL but simply failed not to know how to define the delimiter . ( semicolon )
Plugin works as the Backend/Default query shows correct results.
- What did you expect to happen?
A way to Build Casacade Dashboard Variables from a http CSV source .
- Can you copy/paste the configuration(s) that you are having problems with?
csv looks like this
“[this is the description]some other text”,“hosta”,“interfacea”,“someother fields not needed”
“[this is another description]some other text”,“hostb”,“interfaceb”,“someother fields not needed”
I was able to regex out the needed description in the Brackets . For the first query .
But now i dont know how the get the myhost / myinterface variables defined with a lookup .
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
Not really .
- Did you follow any online instructions? If so, what is the URL?
I have tried to find a solution , but no .
Any help would be real great .
Thx, Dietmar