Reducing Series to First Value

[ebabeshko]

@emilioserra

Next try was to do the reduction in the influxdb query itself:

That could be done by two flux queries. See this example:

Aggregate _Value for each Min and Max timestamp of that value

One of possible ways to do that is to have two queries, one to get Min_Time and another to get Max_Time for every IP. Sample query A: from(bucket: "TEST") |> range(start: -1mo, stop: v.timeRangeStop) |> filter(fn: (r) => r._measurement == "log" and r._field == "message" and r.host == "grafana.host.de" |> group(columns:["_value"]) |> first() |> group() |> keep(columns:["_time", "_value"]) |> rename(columns: {_time : "Min_Time", _value : "I…