Hey,

Using grafana 4.5.2 with Elasticsearch data source.

I am trying to create a table with 3 columns: #1:hostname, #2:network traffic in bits/sec, #3:network traffic out bits/sec

the data in the columns #1 is taken from the group by metric

the datas in columns #2 and #3 each is derivative of query average value of network bytes_recieved and bytes_sent respectively.

Currently I fail to implement it.

When using derivative the table is invalid.

The best implementation I succeeded to do is either display in/out traffic in single column or separate into two tables.

my question: how do I implement single table with values derivative (derivative over time, of last 5m data) as described above?

Currently implemented two tables of type “Time series to rows” tables.

Thanks