Custom Filter on Query Column

[Christine_Davis]

I want to present the average over the last 7 days for a single column. I am trying to use the query column to create the 7 day filter but it doesn’t appear to give me an option to enter as recommended by the chat NOW() - DURATION(“7 days”). I select date, on or after, and then it defaults to “now” with the only alternative option being to select today, date, or this row. What am I missing?

[MaximeBaker]

You might want to create a math column that will calculae now - 7 days:

Then, in the query filter, is two date conditions like this:

So the data will be filtered correctly.

[ThinhDinh]

Then, after you have the query as Maxime suggested, add a rollup column, reference the query, and get the average of the column you need.