How can i convert influxql to flux

InfluxDB 2 Dashboards
, ,
1

I want convert influxql to flux.

SELECT mean("Percent_User_Time") AS "% User Time" 
FROM "win_cpu" WHERE "host" =~ /^$hostname$/
AND $timeFilter 
GROUP BY time($__interval) fill(linear)"

I tried below…that is not work

   from(bucket: "your-bucket-name")
  |> range(start : -10m)
  |> filter(fn: (r) => r["_measurement"] == "win_cpu" and r["_field"] == "Percent_User_Time" and r["host"] =~ /^$hostname$/)
  |> aggregateWindow(every: $__interval, fn: mean, createEmpty: false)
  |> yield(name: "% User Time")
2

@KJ_J I think this will give you what you’re looking for:

import "interpolate"

from(bucket: "your-bucket-name")
  |> range(start : -10m)
  |> filter(fn: (r) => r["_measurement"] == "win_cpu" and r["_field"] == "Percent_User_Time" and r["host"] =~ /^$hostname$/)
  |> aggregateWindow(every: $__interval, fn: mean, createEmpty: false)
  |> interpolate.linear(every: $__interval)
  |> set(key: "_field", value: "% User Time")