Hello team, a question about relative date filters...
# gd-beginners
r
Hello team, a question about relative date filters / default date filters (I looked at the documentation but still feel slightly unclear): When I use the predefined filtering options such as "This year", "last year" or the relative date filters e.g. from 2 years ago to this year, what exactly is the definition? -> is today counted in "this year", "this quarter", "this week"? -> is the year intended as calendar year 1st Jan - 31st Dec? What would be the best option to use if I wanted to set up a date filter for the below use cases: • Date as "Created at" = all past data including today? • Date as "Created at" =all future data including today?
m
Hi Raffaella, date filters in GoodData can be a bit nuanced, when you’re using relative or predefined options like “This year”, “Last year”, etc. Yes - today is included. These are based on the calendar. So “This year” = Jan 1 – Dec 31 (current year) and “This quarter” = based on calendar quarters (e.g., Q1 = Jan–Mar) and “This week” = typically starts Monday, ends Sunday, and includes today if today falls within that week. Relative filters like “from 2 years ago to this year”: The range includes both endpoints. So, “from 2 years ago to this year” (assuming 2025 is the current year) = 2023, 2024, and 2025 (up to today). Hope this helps!
🙌 1
1
r
Super helpful, thanks Michael for the clarifications!