Calendar
The calendar dataset is a comprehensive collection of data points that provides detailed scheduling information for various project activities and milestones. This dataset is crucial for tracking deadlines, managing timelines, coordinating team efforts, and ensuring all project tasks align with overall strategic goals. It enables effective planning, monitoring, and adjustment of schedules, thereby enhancing team collaboration and project success.
Canonical analysis cannot be performed for multiple metrics, such as completed and created work items. Even if it is done as it exists today, it’s important to note that blending across multiple canonical dates is still not possible. These are the limitations associated with canonical dates.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Calendar date | Gregorian calendar date |
| Calendar month | Gregorian calendar month |
| Calendar quarter | Gregorian calendar quarter |
| Calendar week | Gregorian calendar week |
| Calendar year | Gregorian calendar year |
| Day of month | Day of the month between 1 and 31 |
| Day of week | Day of the week between 1 and 7 |
| Day of year | Day of the year between 1 and 366 |
This dataset doesn’t have any metrics.
Use Case: Blending the Calendar Dataset with Base Datasets
You can blend the calendar dataset with existing base datasets by creating a derived attribute based on any canonical date with the DATE data type in the base dataset. The blending happens between this derived attribute and the calendar date from the calendar dataset.
Complete the following steps to create a derived attribute:
- In the DATASET panel, click the three dots and Create Attribute....
- In the Attribute Editor - New attribute window, choose Date and Time > Date, and select the attribute you want to derive from. The function Date('Attribute') converts the selected attribute into a date format, which is crucial for blending.
- Enter name and formula of the new attribute, and click Save to complete the process.
Complete the following steps to blend a dataset:
- In the base dataset, right-click the newly created derived attribute and select Link to Other Dataset.
- Choose the new derived attribute in the base dataset and blend it with the calendar dataset as shown below.