I have a condition:
16 April - 3 May
Week 3 : 16 Apr (Average from 16 - 22 Apr)
Week 4 : 23 Apr (Average from 23 - 29 Apr)
Week 5 : 30 Apr (Average from 30 Apr - 3 May)
I want to have April monthly average numbers based on that three weeks Only when I change the period parameter becomes "Monthly".
But the thing that happens is I got May numbers also.
I will really appreciate for your help. Thank you.
I found two ways you could do this. See the attached packaged workbook. In each case, I ended up with nulls for May and excluded the nulls.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...