-
1. Re: How to make week 1 come after week 52?
Matt LuttonJan 4, 2014 8:40 AM (in response to Efren Castillo)
Can you post a packaged workbook example (.twbx) or some screenshots? I believe its pretty common to see a 53rd week, because of additional days in the year (52*7=364 days).
-
2. Re: How to make week 1 come after week 52?
Efren Castillo Jan 4, 2014 8:52 AM (in response to Matt Lutton) -
3. Re: How to make week 1 come after week 52?
Matt LuttonJan 4, 2014 9:01 AM (in response to Efren Castillo)
I can't really tell what is 2014 or 2013 in the screenshot--with just WEEK(Date) in the view, your results will be aggregated across all years in the data for each week.
There are several ways you could address this; I'm not sure which is best for your scenario and its difficult for me to explain without a workbook. One option would be to place a YEAR(Date) pill on the Columns shelf before WEEK(Date), and you'll get a pane for each year.
Even simpler, I believe if your WEEK(Date) pill is continuous, the issue will resolve itself and dates will be displayed.
But again, I do not know the arrangement of the pills in your view--if this does not help, please post a packaged workbook or some more screenshots of the pill arrangement. Cheers!
-
4. Re: How to make week 1 come after week 52?
Efren Castillo Jan 6, 2014 6:50 AM (in response to Matt Lutton)Week(Date) would work great if instead the actual date, we would be able to see the actual week number.
-
5. Re: How to make week 1 come after week 52?
Matt LuttonJan 6, 2014 7:06 AM (in response to Efren Castillo)
If nobody posts a better solution, I'd add a YEAR(Date) pill to the view, so the years are split by panes, as in my first screenshot above. Of course, if you could color your lines by year, that would resolve your issue as well--but it looks like you're already coloring based on another dimension.
-
6. Re: Re: How to make week 1 come after week 52?
juliette.mccormack Jan 6, 2014 8:04 AM (in response to Efren Castillo) -
7. Re: Re: How to make week 1 come after week 52?
Matt LuttonJan 6, 2014 8:10 AM (in response to juliette.mccormack)
Very nice. Thanks Juliette!
-
8. Re: How to make week 1 come after week 52?
Efren Castillo Jan 6, 2014 9:06 AM (in response to juliette.mccormack) -
9. Re: How to make week 1 come after week 52?
juliette.mccormack Jan 6, 2014 9:23 AM (in response to Efren Castillo)Hi Efren
I can't replicate your problem. Any chance you could post a workbook?
Best Wishes
Juliette
-
10. Re: How to make week 1 come after week 52?
Efren Castillo Jan 7, 2014 11:18 AM (in response to juliette.mccormack)I'm not sure what I did, but now I can see that data. Thanks for all your help!
Cheers!