Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Is mandatory that your filter uses weeks?
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.
Hi,
use as dimension :
Month() + week()
regards