Business Calendar Requirements

Learn more about the data requirements for your custom business calendar.

The business calendar CSV file must contain certain columns to successfully validate against the expected schema. It's defined at a daily granularity, meaning that each day in your custom calendar is accounted for in the CSV file.

The business calendar must contain the following columns:

Column	Description	Required
DateID	The unique identifier of the date in yyyyMMdd, such as 20200701.	Required
Date	The Unix timestamp including milliseconds for the date, such as 1593561600000 for July 1, 2020. Set to midnight UTC.	Required
Year	An integer representing the year in YYYY format, such as 2020.	Required
YearLabelM	The long label that displays in the time slider and chart axis for time in visualizations, such as FY 2020.	Required
YearLabelS	The short label that displays in the time slider and chart axis for time in visualizations, such as FY 20.	Required
Quarter	An integer representing the quarter that the date belongs to, such as 1 for July 1, 2020 to represent that date as part of the first quarter of the business calendar.	Required
QuarterLabelM	The long label that displays in the time slider and chart axis for time in visualizations, such as 1st Quarter.	Required
QuarterLabelS	The short label that displays in the time slider and chart axis for time in visualizations, such as Q1.	Required
Month	An integer representing the month number, such as 1 for July to represent July as the first month of the business calendar.	Required
MonthLabelM	The long label that displays in the time slider and chart axis for time in visualizations, such as July for July.	Required
MonthLabelS	The short label that displays in the time slider and chart axis for time in visualizations, such as Jul for July.	Required
Week	An integer representing the week of the date, such as 1 for July 1, 2020 to represent that date as part of the first week of the business calendar.	Required
WeekLabelM	The long label that displays in the time slider and chart axis for time in visualizations, such as Week 1.	Required
WeekLabelS	The short label that displays in the time slider and chart axis for time in visualizations, such as Wk 1.	Required
FullTimeHours	The number of full-time hours for this date, such as 7.5 for a work day or 0 for a weekend day.	Required
CustomerID	The unique identifier of the customer, such as 00123. This is for WFA legacy support. Note: The column and a value must be present, however, the value can be 0.	Required
DataVersion	The data version of the business calendar. This is for WFA legacy support. Note: The column and a value must be present, however, the value can be 0.	Required

Let’s say your organization’s financial calendar begins in February. The example business calendar below demonstrates correct formatting:

DateID	Date	Year	YearLabelM	YearLabelS	Quarter	QuarterLabelM	QuarterLabelS	Month	MonthLabelM	MonthLabelS	Week	WeekLabelM	WeekLabelS	FullTimeHours	CustomerID	DataVersion
20160131	1454198400000	2016	FY 2016	FY 16	1	Quarter 1	Q1	1	February	FEB	1	FEB-W01	W01	0	54	0
20160201	1454284800000	2016	FY 2016	FY 16	1	Quarter 1	Q1	1	February	FEB	1	FEB-W01	W01	7.5	54	0
20160202	1454371200000	2016	FY 2016	FY 16	1	Quarter 1	Q1	1	February	FEB	1	FEB-W01	W01	7.5	54	0