Introduce Week of Year Dimension Item

[#1]

Description - A "week of year" dimension, that functions similarly to the "month of year" dimension item. "Month of year" allows for year-over-year comparisons at a monthly level and can produce a view where the user can see the raw numbers for current year and previous year along with the percent change between the two time frames.

Why is this feature important to you - I would like to be able to do year-over-year comparisons at the week level where I can also see the percent change. 

How would you like the feature to work - In the same manner as the "month of year" dimension. The values could be 1-52 (sometimes 53) or even better, the month of year and week of the month, for example, "April week 1".

Current Behaviour -In current state, I can only add a time period column, which allows me to see the raw metrics for each time frame but does not allow me to see the percent change.

[#2]

Interesting concept, I have upvoted... however, weeks are always tricky as the first and last week of the year don't line up to have the same number of days, you might end up comparing a week with 1 day to a week with 7 days.....

However, if you limit the comparisons to second week and on, or just put a note for the report audience about weeks not always starting on the same day; I think this could be really helpful.

[#3]

I was thinking more in terms of fiscal weeks for companies. Our Adobe instance is setup to use our fiscal calendar, so with that, a week will always have 7 days, going Sun-Sat, and it wouldn't matter if a week crossed calendar months or years because Adobe "knows" our fiscal calendar. A related example using "month of year": For whatever reason, the first week of our fiscal June was actually the last week of the calendar month of May, but Adobe knows that:

I just thought of another nice feature related to this--to be able to trend the % difference as well

[#4]

Fair enough, but the feature will have to work for every potential configuration (including those that use the standard Gregorian calendar), but I get your point... we don't use the fiscal calendar, so it's easy to forget that it crosses over the year and month designations.

[#5]

Yes, that does make things tricky...would definitely be a game changer for us fiscal folks though! ...and then maybe something Gregorian folks just ignore since it would probably be more trouble than it's worth to use LOL