How to report a bug - ISO Week Number
There is a bug in Spotfire where the week number gets calculated incorrectly by the Week and YearandWeek functions. Please try the functions and compare the results to a ISO 8601 Calendar, especially for the year 2015 and for the last and first week of every year.
I would also like to resuqest that Spotfire include a function that will allow for Week number calculation according ot the ISO 8601 standards. See the ISO_WEEK function offered in SQL.
I need to be able to calculate Week number and YearWeek number where the week starts on Monday, not Sunday