To prepare for this recipe, perform the following steps:
- Use an Enter Data query to create a table called R11_Table with the following columns and rows:
|
Ticket Number |
Opened Date |
Closed Date |
|
1 |
1/4/2020 |
4/15/2020 |
|
2 |
2/8/2020 |
2/15/2020 |
|
3 |
1/14/2020 |
2/3/2020 |
|
4 |
2/4/2020 |
3/12/2020 |
|
5 |
1/29/2020 |
1/29/2020 |
|
6 |
2/18/2020 |
2/19/2020 |
|
7 |
1/5/2020 |
2/24/2020 |
|
8 |
1/5/2020 |
3/2/2020 |
|
9 |
3/3/2020 |
3/15/2020 |
|
10 |
3/6/2020 |
4/13/2020 |
|
11 |
4/1/2020 |
- Ensure that both the Opened Date and Closed Date columns are set to have a data type of Date.
- Create a table with the following formula:
R11_Calendar = CALENDAR(DATE(2020, 1, 1), DATE(2020, 12, 31))
- Ensure that there is no relationship between these two tables.
- On a Report page, create a Clustered Column Chart with the Date field from the R11_Calendar table in the Axis field.
- Ensure that the Date field is set to use the Date hierarchy and remove the Quarter level of the hierarchy.