Grafana tables influxdb source and summing data

Grafana InfluxDB
1

Hi
Working on a Table Dashboard accessing InfluxDB (1.1) with grafana 5
I have a measurement “info” in which I have imported data with the following fields -
Duration Field1 Field 2
40 123 444
10 111 333
10 123 333
10 90 222
10 111 222

What I;ve been asked is to provide a view which shows the total Duration sorted by Field 1
So
Total Duration Field1
50 123
20 111
10 90

and so on

I’m at a loss to work out how to initially approach this - is it something I can do in Grafana or something I need to do first in influx ?
Thanks
(sorry for the edit - his save by mistake)

2

Ok its quite simply an InfluxDB query using
select sum(“DURATION”) from “info” group by “FIELD1”

1 Like