Mysql - hide columns by value in time series graph

Grafana Time Series Panel
1

Hi, I need to hide the columns which have all the same data. To be more clear, I have a table like this (value can only be 0, 1 or 2):

Time      | val1 | val2 | val3 | val4 |
timestamp |   0  |   1  |   1  |   0  |
timestamp |   1  |   1  |   1  |   0  |
timestamp |   1  |   2  |   1  |   0  |
timestamp |   2  |   2  |   1  |   0  |
timestamp |   2  |   1  |   1  |   0  |
timestamp |   1  |   1  |   1  |   0  |

I have to select all the columns (SELECT * FROM …) but not show the ones with all value = 1. So in this example the column Val3 must be hide / deleted from the graph. The time series graph must only show val1, val2, and val4 .
I’m not able to find a solution, neither via mysql query, nor via grafana transformation.
Thanks for your help

2

@donatod

check out this tool I recently discovered. Good for fiddling:

3

Thanks, I’ll give it a look