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


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