import "experimental"

from(bucket: "user-1")
    |> range(start: experimental.addDuration(d: -1d, to: today()), stop: today())
    |> filter(fn: (r) => r["system"] == "2")
    |> filter(fn: (r) => r["_field"] == "ChargeWatt" or r["_field"] == "Duration")
    |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")
    |> map(fn: (r) => ({r with _value: r.ChargeWatt * r.Duration / 1000.0 / 60.0}))
    |> cumulativeSum()
    |> max()
    |> map(fn: (r) => ({r with _time: today(), _measurement: "day-values", _field: "outcome"}))

option task = {name: "whatever", cron: "12 0 * * * *"}

import "experimental"

from(bucket: "user-1")
    |> ...

import "experimental"

option task = {name: "whatever", cron: "12 0 * * * *"}

from(bucket: "user-1")
    |> ...