Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Functions
Created by Guest
Created on Nov 24, 2021

Add ISOYear to BinByDateTime

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)>

  • Attach files