Chris Kyriacou Posted February 11, 2020 Share Posted February 11, 2020 Hi All, I have found that when using the following BinByDateTime function on the X axis, I get repeating weeks, where one week is empty. BinByDateTime([Date],"yy.mm.wk",2) See the image below: Why is week 5 of 2020 repeated, and the second instance is empty Using Spotfire version 7.11. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted February 11, 2020 Share Posted February 11, 2020 It might be bcause it is referring to data on 1st February,2020. Which is part of that 5th week but it could be there is no data for that day. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted February 11, 2020 Share Posted February 11, 2020 Add an Hierarchy of Year([column]), Week([Column]). This might give a better result Link to comment Share on other sites More sharing options...
Chris Kyriacou Posted February 12, 2020 Author Share Posted February 12, 2020 Thanks Shandilya, great solution! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now