change start of week in Data Flow (Advanced Time Intelligence)
I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by Avi Perez in the Product Ideas forum.
note: In the advanced widget I set my Start of the year as 29/03 Current year and the start of Week as "Sunday" and Data Model Target is a MS-SQL Server.
I'm attaching my results below, as it's returning a strange day/week combination in the result.
notice that the weekday number is correct, yet the "week" allocated is incorrect.
ie: in my weekday number the start is correctly computed as Sunday, yet in the "week" it comes through a Saturday.
Please share any suggestions if you've perhaps come across the same issue.
Cheers and thanks in advance
This is fixed in 2020.10. Please upgrade and retest.
Hope that helps.