Week to date Filter

1

Hello,

I do weekly dashboards and I am using the date filter.
I would like to set the date filter as “This date to week” instead of a 7 days period.
I have tried to put Previous 0 week including this week but it does not work as expected.
As well, when I do weekly charts, I would like to have data displayed on week (Monday to Sunday).

An admin settings to set the first day of the week (Sunday or Monday) would be a nice bonus.

Thanks in advance,
Jérémy

2

Hi @jeremy-esus
I’m not sure what you’re trying to do, but it sounds like you’re looking for “Current: Week”, which already exist?
As for defining start-of-week:
https://github.com/metabase/metabase/issues/1779 - upvote by clicking :+1: on the first post

3

I feel like a Week-To-Date filter is different than Current-Week filter. Say today is Thursday and it's a Monday-Sunday Week:

  • Week to Date = Monday-Thursday records
  • Current Week = Monday-Sunday records.

It really only matters if you have future records, but that isn't that uncommon.
That said, Week-To_Date is a nice-to-have feature, given that you can create the filter using SQL:

WHERE <date_field> >= date_trunc("week", CAST(current_timestamp() AS timestamp)) AND <date_field> < date_trunc("day", CAST(current_timestamp() AS timestamp))

4

@marcellom Quite sure you're looking for something different than original poster, but there's a specific request for what you're after (which we're working on):
https://github.com/metabase/metabase/issues/19274

1 Like