AggregateWindow example: calculate gain per window (hourly daily monthly)

[neonarc4]

from(bucket: "Neo")
  |> range(start: -1h)
  |> filter(fn: (r) => r["_measurement"] == "async_m")
  |> filter(fn: (r) => r["_field"] == "current")
  |> filter(fn: (r) => r["location"] == "raza")
  |> aggregateWindow(every: 1h, fn: sum)
  |> spread()
  |> yield(name: "sum")

calculate hourly total gain of daily and monthly and total
const data = total ,gain
hourly - data
daily - data
monthly - data
total - data

[jstirnaman]

This might be a good example to include for all products

[jstirnaman]

Hi, I recommend posting your questions to the InfluxDB Community on Slack: https://join.slack.com/t/influxcommunity/shared_invite/zt-2a0yuh9pc-fJqrDaBoSqWzHgYnZhofIg

…

On Fri, Dec 29, 2023, 3:24 AM neonarc4 ***@***.***> wrote: @jstirnaman <https://github.com/jstirnaman> can u give me any hint how it possible on influxdb2 right now recently few month started influxdb i want to learn first before buying v3 hosting i wonder this calculation cost so much load on influxd if i set an interval 5sec i need to fetch previous next month then i need to subtract is their an efficient way of doing it like single query bring gain and loss — Reply to this email directly, view it on GitHub <#5284 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AABT2A27JB6GYG63SP3LMWDYL2D6XAVCNFSM6AAAAABBDLSDW6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZRHA3TAOBQGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[neonarc4]

got the answer thnx man