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?
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.
1 Like
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.
1 Like