Is it possible to have a line chart with actual week end date (for current year) showing current year and prior year metric values? I see most solutions offer using week number. I need actual week end date. The data is weekly with week end date is the data file. Sample below . Thanks
Sep 5, 2018 3:38 PM
Please attach sample data as twbx format.
And could you clarify how you align this year's date and previous year's date?
Thanks,
Shin
The actual date in the data would identify which week in the calendar year. For example 1/7/2018 and 1/8/2017 are week 3 for their specific year.
Sep 5, 2018 5:25 PM
Which day of week YOUR week starts?
Shin
Sep 5, 2018 5:54 PM
Not exactly sure about your fiscal calendar logic, but hope this is close.
Thanks,
Shin
That might work. I was hoping to show the actual date and not the week number. Thank you.
Sep 6, 2018 5:03 PM
Hope this helps.
If this helped, please mark my answer as correct/helped to close the thread, not from inbox but from original post.
Thanks,
Shin
Thanks Shin. Interesting approach. This won't work with daily dates. I need the week date. I tried to change the logic in your Normalized Date calc to give me week date but not having any luck.
Sep 7, 2018 7:49 AM
Sorry I am not quite sure what " I need the week date" means.
Could you please illustrate your expectations?
Thanks,
Shin
I played around with a calc for date and came up w/ something that would give me the week end date (or weekly date) for the current year and was able to align the previous year's date to that. However I think it will be a problem when there is a leap year.
Sep 7, 2018 8:27 AM
That 100% depends on your fiscal weeks' definitions.
How your company determines the very first fiscal week's start date for each year??
for example,
in some cases, January 1st becomes previous year's week 53,
some cases, January 1st is always the trigger of new year Week-1 with knowing there is less than 7 days week..
Thanks,
Shin