Create a custom start day for calculating a week on a Date variable
complete
Y
Yellow green Stoat
On a date variable when you use the week aggregation the default is to have the week start on a Monday and end on Sunday. I have been asked a few times to have the ability to customize when a week starts and ends. The customer would like to have the ability to select when a week start as an example, to have the week start on a Sunday and end on a Saturday.
D
Dawn Mischewski
marked this post as
complete
You can now set a Period anchor when you aggregate a Date/Time variable to set the first day of each period. Pick any date, and all periods align to it. Weeks don't have to start on Monday, months don't have to start on the 1st, and fiscal quarters can align to whatever calendar you report against.
The control appears in the Date/Time Aggregation dialog whenever the aggregation is Weekly, Biweekly, 4 Weekly, Monthly, Quarterly, or Yearly. A Preview section shows the resulting periods before you commit.
D
Dawn Mischewski
marked this post as
planned
J
Jamie Morris
marked this post as
backlog
J
Jamie Morris
marked this post as
under review