Grafana CSV -> Table dynamic update

Grafana Dashboards
1

Hi,

I am using Grafana 10.3.3.

I am using Infinity-CSV-UQL parser combination with inline CSV data in below format -

Profile,Slice
1-SASE,5000
12-Production,100
19-Test, 200
…

Now my requirement is to fetch multiple records from this CSV data based on multiple values of the column “Profile” using a single query with parse-csv command.

I am able to fetch a single record using the below UQL query-

parse-csv --delimiter ‘,’ --ignoreError true
| where “Profile” == ‘1-SASE’
| project “Slice”

But not able to extend it to fetch multiple records based on different values of the column “Profile”.

Any idea how to achieve that ?

Please let me know.

Thanks,
Nilanjan

2

Hi,

Would something like this work or does it have to be UQL?

3

Hi ,

It need not be UQL.

It would like to fetch both the records ( With Profile,Slice columns ) when “Profile” value is equal to “1-SASE” or “12-Production” using a single query in Grafana and show the result in a tabular format.

The table should show as below -

Profile Slice
1-SASE 5000
12-Production 100

Need to achieve this using a single query in Grafana where the “Profile” column values would come as variables.

Any way to achieve this in Grafana ?

Please let me know.

Thanks,
Nilanjan

4

where the “Profile” column values would come as variables

As Grafana built-in variables or known beforehand?
If known beforehand, something like this (which was mentioned in the link) should work (with backend parser), e.g.:

image
image494×213 10.6 KB

If you meant Grafana built-in variables, it’s a bit trickier, so I’ll look into it if you say so.