I’m preparing table with many columns.
Let’s say I use column A and B for transformation (calculating A/B) and I want to show only result of this transformation in table.
However I can’t use “replace all fields” because other columns (C, D, E…) will be also replaced.
And I can’t use “disable/enable query” option, because then calculation is not done.
What is your datasource? Could you build your query to do the A/B calculation and then have Grafana display that new query? I have done this in Grafana as well and can show you an example, but I use Influx so my query may not make sense for your datasource.
But this unfortunately will not work for Transformation. When I hide a Query then the Transformation can’t count (reduce row) columns
Thus I have to use “replace all fields” in the Transformation which is sad. Is it possible to hide a single Query and still have the Transformation operation working?