Can anyone help me figure out this issue? I restructured my database, and have to fill in historical data into the new format. For some reason, the historical data comes out in a different table when I query it, even though all the values in the group key are identical. If I call
group() using the same group key, they all end up in 1 table, but I don’t want to have to do that every time I query the database.
Here’s the flux that generates that result:
from(bucket: "power_circuit_lores") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "kw") |> filter(fn: (r) => r["_field"] == "pair_min") |> filter(fn: (r) => r["circuit_pair_id"] == "3303") |> yield(name: "mean")
Running on InfluxDB OSS 2.6.1