Multiply two field values and store the result in a new field

21

@scott Can you please throw some light on this. Thanks in advance.

22

@samdanisms integral() is an aggregate function that outputs a single row table for each input table. To get the daily usage, use aggregateWindow() with integral(). Because integral() requires you to specify the unit, you need to use the following syntax:

// ...
  |> aggregateWindow(
    every: 1d,
    column: "power",
    fn: (tables=<-, column) => tables |> integral(unit: collectionInterval, column: column)
  )
1 Like
23

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.