Hello @mm0001,
I don’t exactly know what you mean by pick up data on every Friday.
Here’s how I filtered for data that’s only written on a Friday and then performed an aggregate window.
import "date"
from(bucket: "noaa")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "average_temperature")
|> filter(fn: (r) => r["_field"] == "degrees")
|> filter(fn: (r) => r["location"] == "santa_monica")
|> map(fn: (r) => ({ r with weekday: date.weekDay(t: r._time)}))
|> filter(fn: (r) => r.weekday == date.Friday)
|> aggregateWindow(every: 1d, fn: mean, createEmpty: false)
|> yield(name: "mean")