Get rid of _measuremet _field

Fluxlang
1

Hi.

I want to get max temperature per day. I use aggregatewindow but i cannot get rid of some columns in output table.

Query:

from(bucket: "openhab/autogen")
  |> range($range)
  |> filter(fn: (r) => r._measurement == "Vitocal_Aussentemperatur" and (r._field == "value"))
  |> aggregateWindow(every: 1d, fn: max)
  |> keep(columns: ["_time", "_value"])
  |> rename(columns: {_value: "Max"})

Result:

image
image1909×844 74.7 KB

I only want the “Max” column. How to achieve this?

best regards

2

Hello @dominikbenner,
Welcome! I recommend using the keep() function.
> keep(columns: [ "Max"])