Usefulness:
Using the current BinByDateTime expression, users can create a continuous X-axis in visualisations for Year>>Month, Year>>Quarter, etc.
This isn't possible for Year>>Week, as for instance January 3rd of 2021 belongs to ISO week 53 of 2020.
Only being able to create a categorical X-axis causes the problem that we cannot show data ranges for which there are no data points.
For instance: we have data from Dec20-Jan21 and Jun21-Aug21. There is no way of showing empty values for February-May 2021.
For who: People that use the Nest of Year & Week on the X-axis.
This also solves the problem that
<BinByDateTime([Date],"Year.Week",1)> will show January 3rd, 2021 in the visualisation in week 53 of 2021, so the end of the year.
For this we now have to use a workaround with a calculated ISO Year column and the expression:
<[ISOYear] as [Year] NEST BinByDateTime([Date],'Week',0)>
How: Using <BinByDateTime([Date],"ISOYear.Week",1)>
It would be nice if we could mix ISO and non-ISO hierarchy levels especially on not ISO appliable.
For example <BinByDateTime([Date],"ISOYear.Month.ISOWeek",1)> as there is no ISO month.
So far we only have the choice between
BinByDateTime([Date],"ISOYear.ISOWeek",1) which do not include Month option
BinByDateTime([Date],"Year.Month.Week",1) which do not use ISO standards