How to make "All" variable work in transformations?

[vishalpanuganti98]

I am using the transformation ‘filter field by value’, and using ‘Column name’ is equal to ${variable_name}. However when I’m using “All” option I think the transformation is doing column name is equal to “All” instead of selecting all the values. How do i address this issue?

[infofcc3]

Step 1 : create variable

Step 2: select datasource and fetch data by query

Step 3: Add transformation

[vishalpanuganti98]

I forgot to mention I am using infinity plugin. Is the syntax still the same?

[infofcc3]

Using this postgresql query Select * from table name i fetch data from database and display on panel , you can use these data formats to fetch data on panel in infinity plugin.

and then apply transformation simply.
just fetch data and disply on panel then remain step is same for transformation.

[yosiasz]

What data type are you using? JSON or csv?

[infofcc3]

hello @vishalpanuganti98 please confirm problem is resolved or still facing issue.

[vishalpanuganti98]

Im using csv

[vishalpanuganti98]

Im still a bit confused. Im using UQL to fetch the data.

Here when I try to write the condition, Business Id is equal to ${BusinessId} and select All option from the drop down. I think it equates Business Id is equal to All, instead of selecting all the values. Because I get No Data on my panels after selecting “All”

[infofcc3]

Filtering data | Grafana Plugins documentation

follow this doc it will help to filter the data and display on panel.

[yosiasz]

please share what the variable configuration for BusinessId looks like

All

Single filter

[vishalpanuganti98]

[yosiasz]

You need to tick Include All option

[vishalpanuganti98]

Yes, I understand but in my transformations I apply Job Name is equal to “${BusinessId}” when I select “All” option I get no data I think internally the transformation is equating “Job Name” is equal to “All” instead of selecting all the values

[yosiasz]

One way to find out is click on query inspector of the main dashboard query and see data tab