Data Dictionary
Field | Type | Notes |
Calendar Half End | Date | The last day of the half year e.g. 30 June 2024, 31 Dec 2024. Useful in filters; a relative date filter for all Calendar Half End values in the past 2 years, would ensure that you have data that has 4 completed Calendar Halfs. |
Calendar Half Name | Text | The name of the half year; e.g. 2024 H1, 2024 H2 |
Calendar Half Short Name | Text | e.g. H1, H2. Useful when comparing the same halves from different years. |
Calendar Half Start | Date | The first day of the half year e.g. 1 January 2024, 1 July 2024. Useful in filters; a relative date filter for all Calendar Half Start values in the past 2 years, would ensure that you have data that has 3 completed Calendar Halfs, and the current Calendar Half. |
Calendar Month End | Date | The last day of the month. A relative date filter for all Calendar Month End values in the past year will ensure that you have 12 completed months of data. |
Calendar Month Name | Text | e.g. February 2023 |
Calendar Month Number | Integer | e.g. 2 |
Calendar Month Short Name | Text | e.g. February |
Calendar Month Start | Date | The first day of the month. A relative date filter for all Calendar Month Start values in the past year will ensure that you have 11 completed months of data, and the current month. |
Calendar Quarter End | Date | The last day of the quarter. Useful in filters as per Calendar Half End and Calendar Month End. |
Calendar Quarter Name | Text | e.g. 2023 Q2 |
Calendar Quarter Short Name | Text | e.g. Q2. Useful when comparing the same quarter from different years. |
Calendar Quarter Start | Date | The first day of the quarter. Useful in filters as per Calendar Half Start and Calendar Month Start. |
Calendar Year As Number | Integer | e.g. 2023 |
Calendar Year End | Date | The last day of the year; e.g. 31 December 2023 |
Calendar Year Name | Text | e.g. '2023' |
Calendar Year Start | Date | The first day of the year; e.g. 1 January 2023 |
Date | Date | The Dates key value to use to create relationships with other tables. |
Iso Year As Number | json | e.g. 2022 |
Iso Year End | json | The end of the ISO Year e.g. Sunday 1 January 2023 (which is the ISO Year End for the ISO Year 2022, which started on Monday 3 January 2022) |
Iso Year Half End | json | The end of the ISO Half Year e.g. Sunday 3 July 2022 |
Iso Year Half Name | json | e.g. 2022 H1 |
Iso Year Half Short Name | json | e.g. H1 |
Iso Year Half Start | json | The start of the ISO Half Year e.g. Monday 4 July 2022 |
Iso Year Month End | json | The end of the ISO Month e.g Sunday 29 May 2022 |
Iso Year Month Name | json | e.g. May 22. Note that ISO Months can be much shorter than Calendar Months; ISO Year May 2022 only had 28 days; starting on 2 May and finishing on 29 May. |
Iso Year Month Short Name | json | e.g. May |
Iso Year Month Start | json | e.g. Monday 2 May 2022 |
Iso Year Name | json | e.g. '2022' |
Iso Year Quarter End | json | e.g. Sunday 3 April 2022 |
Iso Year Quarter Name | json | e.g. 2022 Q1 |
Iso Year Quarter Short Name | json | Q1 |
Iso Year Quarter Start | json | e.g. Monday 3 January 2022 |
Iso Year Start | json | e.g. Monday 3 January 2022 |
Iso Year Week | json | e.g. Week 8 |
Iso Year Week End | json | e.g. Sunday 27 February 2022 |
Iso Year Week No | json | e.g. 8 |
Iso Year Week Start | json | e.g. Monday 21 February 2022 |