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.
Tip: The CSV file must contain a header line with the column names, and all rows must be sorted in ascending date order.
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 2000. |
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 |