Horizontal table

Grafana
1

Is there a way to create a ‘horizontal’ table i.e. to have the time index as columns?
I have two time series. The first one I would like to plot as a graph. The second one corresponds to the values of the first one, but I would like to show these values as numbers above or below the graph.

2

Can you give an example? What would the first row in a “horizontal” table look like?

3

I would like to transpose a table.
The rows would be the values of a time series.

A little like this:

4

Sorry to revive an old thread, is there any way to do this in Grafana v5?

It makes showing multiple measurements in a table more space efficient, especially in my case using InfluxDB and grouping by multiple tag values.

5

Hi @daniellee
this is my issue too.
Would you please answer is this possible?

many thanks

6

@daniellee
Would you please give an answer?

7

@moh3n I don’t think it is possible.

8

@daniellee
Why do you think it is impossible?
There are many Dashboards that using horizontal table.
and technically you need to query the data per row instead of columns.
As far as i know nothing is not impossible in IT word

9

Hello @moh3n,

I use this king of Query with InfluxDB … maybe dirty but do the job !

Example with telegraf metric:
Query for 1st Col : Yesterday
SELECT DISTINCT(mean) AS "Yesterday" FROM (SELECT mean("usage_user") FROM "cpu" WHERE ("host" =~ /.*/) AND time >= now() - 1d and time <= now() -0h GROUP BY "host")GROUP BY "host"
Query for 2nd Col : now() - 24h
SELECT DISTINCT(mean) AS "Day -2" FROM (SELECT mean("usage_user") FROM "cpu" WHERE ("host" =~ /.*/) AND time >= now() - 2d and time <= now() -1d GROUP BY "host")GROUP BY "host"
Query for 3rd Col : now() - 48h
SELECT DISTINCT(mean) AS "Day -3" FROM (SELECT mean("usage_user") FROM "cpu" WHERE ("host" =~ /.*/) AND time >= now() - 3d and time <= now() -2d GROUP BY "host")GROUP BY "host"
etc …
I use DISTINCT function to avoid the timestamp and hide Time col in Visualization