Hello,
I have a query which currently shows me how many aircraft have passed close to my home today:
from(bucket: "ReadsbMonitor")
|> range(start: today())
|> filter(fn: (r) =>
r._measurement == "aircraft" and
r.Call != "")
|> keep(columns: ["Call"])
|> group(columns: ["_time"], mode: "by")
|> unique(column: "Call")
|> count(column: "Call")
gives me a numeric result:
My question is, how can i check what the result of this query was on previous days? can i maybe write the result of this query once per day to a new measurement maybe?
I’d ultimately like to get a bar graph with a daily value for how many aircraft were seen per day. note that i can not just aggregate over several days, since i have the unique() function in my query - if an aircraft passes over me several times it would only count it once.
