how to hide the "time" column in the table when use Grafana with influxes

Question

When I use table visualisation in Grafana with InfluxDB, the table panel always shows the time column, but I do not want it. So how can I achieve this?

I have searched similar questions on StackOverflow, but could not find any answer. My query does not include time as shown below:

"SELECT sum("load") AS "load" FROM "cpu" WHERE $timeFilter GROUP BY "host""

But the table panel looks as follows including the time column:

score 17 · Answer 1 · answered Jun 24 '20 at 07:17

17

This answer is for Grafana version 7.0.3 and later (previous versions 7.0.1 and 7.0.2 had related bugs which were fixed).

You can do this by adding the "Organize fields" transformation. Click "Transform" tab -> Click "Select" button on "Organize fields" row -> Click the "eye" icon on "Time" row.

answered Jun 24 '20 at 07:17

Jackson

362
3
10

This is the correct answer if you are using grafana v7.5.7 – Reyansh Kharga Jul 19 '21 at 09:27

kahveci · Answer 2 · 2019-09-29T13:12:43.960

3

You can hide the default time column using "Column Styles" in "Visualisation" tab. You must match the column name either by name or with a regex, and finally choose type "Hidden" as follows:

edited Sep 29 '19 at 13:12

answered Sep 29 '19 at 11:20

kahveci

1,429
9
23

1

Is this option gone in v7?? – MikeKulls Jun 20 '20 at 14:58
1

@MikeKulls, did you find the solution in new version? – Beliaev Maksim Jun 23 '20 at 16:27
5

@BeliaevMaksim I did. It was actually so obvious I missed it. Next to query there is a tab named transform, you tick the columns on and off there – MikeKulls Jun 24 '20 at 13:51
2

@MikeKulls, ou hell, I found it, thank you very much! Hidden under the nose :D – Beliaev Maksim Jun 25 '20 at 14:31

how to hide the "time" column in the table when use Grafana with influxes

2 Answers2