Hi,
I have one measurement which contains tagged values for current an voltage. I want to calculate the value for power out of current and voltage. To achive this I joined the datasets for both values. The problem is that both values can have very different timestamps: e.g. current is at the same level for let´s say an hour. But voltage can change within seconds. There is a big rectifyer which should produce a constant current…
So I tried to put current and voltage in the same timewindows (10 seconds) . The problem is that if the e.g. the current is stable there will be many empty or missing timeslots. I tried for hours getting a solution.
from(bucket: "bde")
|> range(start: dashboardTime)
|> filter(fn: (r) =>
r._measurement == "aggrproto" and
r._field == "aggrvalue" and
r.aggrid == "Agg365GLR.IstwertI")
|> window(every: 10s)
|> mean()
|>fill(usePrevious: true)
Maybe you guys have an idea to get this working…
