Custom calendar
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.
Report builder uses the Analytics custom calendar. You can use the calendar to define the first day of the week and year, or use a different retail calendar style. The calendar formats are used to for various purposes, including sales comparison and forecast standardization, payroll cost analysis, or physical inventory count regulation.
Each of the calendar formats is described below.
Offers three formats based on the number of weeks in each month. The number of weeks in each month depends on the selected first day of the year.
A year has 52 weeks. Divide that into 4 quarters and you get 13 weeks per quarter. But there are 3 months in a quarter. 13 is not divisible by three so you end up putting the extra week into one of the months so that it's always consistent. 5/4/4 means the 1st month of the quarter has the extra week. 4/5/4 means the 2nd month has the extra week, etc. In the 5-4-4 calendar, the 53rd week is added onto the last quarter of the year.
- 4-5-4:January has four weeks, February has five weeks, March has four weeks, and so on.
- 4-4-5: January has four weeks, February has four weeks, March has five weeks, and so on.
- 5-5-4: January has five weeks, February has five weeks, March has four weeks, and so on.
Note: This calendar option is supported across all ÃÛ¶¹ÊÓƵ Analytics tools: Analysis Workspace, Report Builder, and Activity Map. The exception is Data Warehouse, which does not support custom calendars.