Different window periods for different columns

I want to make a scatter plot in Grafana where I show column a over column b. However, I want column b to be the daily mean. So I would expect the column to have the same value multiple times for each value of a for that day.

I tried with union but then I only get the daily values for both.

Hmm I’m not sure I really understand what you mean.
Can you please share an example of your input and what you want your expected output to be?

Ohhh wait i think I get it.

Okay I think you’ll actually want to perform a join instead.