LPAREN error for Flux query

Grafana InfluxDB
,
1 
import "math"

from(bucket: "Lybover")
 |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
 |> filter(fn: (r) => r["topic"] == "RAGG_UF_Flow")
 |> filter(fn: (r) => r["_field"] == "metrics_0_value")
 |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
 |> filter(fn: (r) => r["host"] == "machinedatalinux")
 |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
 |> map(fn: (r) => ( _time: r._time, _value: math.sqrt((2.0 * r._value) / 2232.93)))
 |> yield(name: "mean")
2

In your query, the issue is likely in the map() function.

import "math"

from(bucket: "Lybover")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["topic"] == "RAGG_UF_Flow")
  |> filter(fn: (r) => r["_field"] == "metrics_0_value")
  |> filter(fn: (r) => r["_measurement"] == "mqtt_consumer")
  |> filter(fn: (r) => r["host"] == "machinedatalinux")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> map(fn: (r) => ({
      _time: r._time,
      _value: math.sqrt((2.0 * r._value) / 2232.93)
  }))
  |> yield(name: "mean")
3

Welcome @didiertimmerman

If you run your query in Influx Data Explorer, the debugger will tell you the line number and space where the LPAREN error is occurring.

1 Like