Week calculation

[qv_testing]

Hi Community,

Week numbers are often  used in calendar, we can create simple way WEEK(DATE) i.e 52/53 weeks.

I'm facing issue with Week level data, my users wants to show like below

Week 1

Week 2

Week 3

Week 4

Jan Week 5

Feb Week 5

Week 6

Week 7

Week 8

Feb Week 9

Mar Week 9

Week 1 to Week 4 under Jan month, but Week 5 is both in Jan and Feb... so it is not taking correct value.

I want Bifurcate 2 levels, like Jan Week 5 and Feb Week 5  and so on...

Any possibility??

Experts please suggest any better way....

Thanks in Advance!!

[eduardo_dimperio]

Is mandatory that your filter uses weeks?

[Anil_Babu_Samineni]

Not sure about your user needed. As i ma user, This is not make sense to me. If you select week 5 then what data will come up to the picture.

[ogautier62]

Hi,

use as dimension :

Month() + week()

regards