Best method for drilling from year/month to weeks within month, and capturing all days in the month

Dan Rosen

Does anyone have an advised method for drilling from year/month to weeks within month, and capturing all days in the month. With the built-in drill to week start date, it will cut off the first few days of the month since the week started in the previous month.

I tried drilling to week number and am having some mixed results with how the days roll up.

Any ideas?

Dan Rosen

I've learned now this is due to ISO view of the day the week starts determining the month it falls into unless you're at the day level.

I worked through how to best present proper business weeks (partial first, full second, etc.) as opposed to the day of week in month (1-7, 8-14, etc.)

I landed on this:

Or more simply:

The only issue I found here is that this now forces the use of the day level and so it messes up % calculations. Will have to keep exploring.