Use variables as transformation

Hi, I’m new to Grafana, and I have a table in which I want to display the data of only the rows in which a number in column E is equal to an input from the dashboard.

image

I want to update the transformation in order to filter the data in the graph, here is an example transformation:

here is my variable:

so how do I instead of manually inputting a number put a variable?

See this answer

I would use transformations judiciously. I personally use them where you cannot do what you need to do in the datasource itself. then you leave grafana to do what it does best => visualization

what is your datasource?