Feature Request: Support for table to dataframe Grafana format to Enable transformations?

[toni-moreno]

I've found could be useful to have data tables as dataframes in Grafana.

by example in this case could be fine if we can transform this table.

┌─t─┬─cat─┬─errors─┐
│ 1 │   3 │     24 │
│ 1 │   4 │     84 │
└───┴─────┴────────┘

in this other ( grafana dataframe ready to handle transformations) .

+---------------------+-----------------+-----------------+
| Name: time          | Name: errors    | Name: errors    |
| Labels:             | Labels: cat=3   | Labels: cat=4   |
| Type: []time.Time   | Type: []float64 | Type: []float64 |
+---------------------+-----------------+-----------------+
| 1                   | 24              | 84              |
+---------------------+-----------------+-----------------+

 I'm newbie in clickhouse, but after some days working with clickhouse  plugin 2.3.2 data and grafana 7.5.5 , I didn't found any solution for this.
There is any way to do that?  (special column naming may be?) 

Thank you very much for your patience

[Slach]

need to create ./docker/grafana/dashboards/issue_404_tranformation_table.json
where
table default.test_grafana

SELECT service, count() AS value 
FROM $table

or

$columns(service, count() AS value) 
FROM $table

format As Table
and use transformation to transpose rows to columns in Grafana