Use values to calculate a new column

This example uses NOAA water sample data.

This example converts temperature from Fahrenheit to Celsius and maps the Celsius value to a new celsius column.

The following query: - Uses filter() to filter the average_temperature measurement. - Uses map() to create a new column calculated from existing values in each row.

from(bucket: "noaa")
  |> filter(fn: (r) => r._measurement == "average_temperature")
  |> map(fn: (r) => ({r with
      celsius: ((r._value - 32.0) * 5.0 / 9.0)
    })
  )

Example results

queries