Week of Month in Month over Month

[trprado]

Is it possible to use the timeframe to create a week_of_month like a week_of_year? I need to show a graph of Month over Month but using measures by a week of the month.

[Dawid]

There’s no native Looker support for week_of_month but you could build it yourself, depending on your dialect.

The problem is that 1st week of the month will be very different. If you work on Mon-Sun ISO weeks then 1st March was Sunday, that would mean the 1st week has only one day compared to two days in February.

Of course comparing 2nd and 3rd week gets easier as you are certain there are always full weeks. With the 4th one you may get different number of days again…

[Minh_Tran1]

Time comparison master