monitoring-service
    Preparing search index...

    Class UtilityMetersQueryBuilder

    A small builder utility for constructing Flux queries targeting InfluxDB for utility-meter data.

    It provides a fluent API that allows to:

    • select a buck
    • optionally filter by household user
    • choose between last value queries or cumulative (integral) queries, depending on whether a custom start/stop time is provided
    from(bucket: "utility")
    |> range(start: -25s)
    |> filter(fn: (r) => r._field == "value")
    |> last()
    |> group(columns: ["_measurement"])
    |> sum()

    import "date"

    from(bucket: "utility")
    |> range(start: 2025-11-28T00:01:00Z)
    |> filter(fn: (r) => r._field == "value" and r.householdUserUsername == "alice")
    |> integral(unit: 1h)
    |> group(columns: ["_measurement"])
    |> sum()
    Index

    Methods

    build withStart withStop withUser withZone forBucket

    Methods

    • Parameters

      • Optionalfrom:
            | `${number}minute`
            | `${number}minutes`
            | `${number}hour`
            | `${number}hours`
            | `${number}day`
            | `${number}days`
            | `${number}week`
            | `${number}weeks`
            | `${number}month`
            | `${number}months`
            | `${number}year`
            | `${number}years`

      Returns UtilityMetersQueryBuilder

    • Parameters

      • Optionalto:
            | `${number}minute`
            | `${number}minutes`
            | `${number}hour`
            | `${number}hours`
            | `${number}day`
            | `${number}days`
            | `${number}week`
            | `${number}weeks`
            | `${number}month`
            | `${number}months`
            | `${number}year`
            | `${number}years`

      Returns UtilityMetersQueryBuilder

    Settings

    Member Visibility

    On This Page

    UtilityMetersQueryBuilder
    Methods