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.