Bugs in weekly time selector
-
With the following weekly data, the default DE viz display (using DLM preview) auto-selects 2020 W53, which doesn't represent the last available data (2021-W11 is the last available time period).
-
When switching the end period from unselected "----" to "2021" then a wrong SDMX query using W53 is generated, which results in the NSI failing, because week 53 doesn't exist for 2021 (while it exists for 2020). Instead the highest available week number 11 for 2021 should be displayed.
-
In "End" filter when changing year in the filter "2020 W53" from 2020 to year 2019, week 02 is automatically pre-selected.
-
2018-W01 is automatically pre-selected in the time period start, although the data availability TimeRange StartPeriod is 2018-12-31T00:00:00. For 2018 there is only week 01 selection (correct would be to identify this date as 2019 week 01).
-
It is not always possible to select week 52 of the year 2019 in the "End" filter, as it jumps to the "week 01" value. "Week 52" gets selected when you choose "Week 51" in the filter.
- structures: MDP_INDICATORS.xml
- data: data_mdp.xml
Information on week numbers:
See: https://sdmx.org/wp-content/uploads/SDMX_2-1_SECTION_6_TechnicalNotes.pdf, page 16:
There are either 52 or 53 weeks in a reporting year. This is based on the ISO 8601 definition of a week (Monday - Saturday), where the first week of a reporting year is defined as the week with the first Thursday on or after the reporting year start day. The reporting week is always represented as two digits, therefore 1-9 are 0 padded (e.g. 01). This allows the values to be sorted chronologically using textual sorting methods.
See: https://www.epochconverter.com/weeknumbers
Week number according to the ISO-8601 standard, weeks starting on Monday. The first week of the year is the week that contains that year's first Thursday (='First 4-day week'). ISO representation: 2021-W12