I want to use data from my CSV file as data source in Grafana 10
I know how to use variables to filter data from MySQL query but I don’t know where to filter CSV data with variables. There is no explicit place to put in variables like in MySQL query.
Hello, I would like to know if you managed to solve this problem? I’m trying to make dynamic panels in Grafana from CSV files but I can’t link variables to the panel.
It is not clear what you are trying to do? What are make dynamic panels and what do you mean by but I can’t link variables to the panel.
Thank you for your response. I will try to make myself understood. I already managed to create the variables, as shown here. But in the part of the query, where the variable is associated, it does not allow me or I do not know how to associate variables when I have csv format.
Below documentation can be used to achive multi input
I have used ‘${servers:csv}’ to achive manual multi inputs where I am passing multiple inputs on the fly, this is useful when one can not add these values in a predefined dropdown values
Hello Manu, can you give a step to add variable to csv data pulled from API.
are you using infinity plugin?
Yes using Infinity plugin
check out uql with parse-csv and filter documentatiom, try it out and post when stuck
https://grafana.github.io/grafana-infinity-datasource/docs/uql
this wont work for grafana visualization
Using variables to filter data from a CSV allows for more dynamic and flexible data analysis by specifying conditions based on those variables. You can achieve this in programming languages like Python by using libraries such as pandas. Just as a lube oil pump ensures the precise distribution of oil to keep machinery running smoothly, using variables to filter data helps streamline your analysis, ensuring you get the exact insights you need efficiently.