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
  • Guest
    May 21, 2025

    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