(Check out our time range controls page for more specifics.). You can also use an offset in the window() function. Just out of curiosity, has this feature been added if this request was closed? To display the full period of the unit (such as day, week, or month), append /