Forum Discussion
Invert x axis
Understood! Then I would create a date table, set the relationship up and use the new date table column as the sort by. I believe that should work.
Alright, I'll try that. Thanks!
Hi,
When I try to sort by the column "tracestamp" (where I got my YEAR and WEEKNUM), I get the following message.
Here is my formula:
Okay, sounds like a data cleansing issue. I've just managed to reproduce the steps and it works fine. Do you have duplicate dates in the timestamp column? Are they necessary?
Yes there are definitely duplicates. The timestamp is the time that the data was imported, and I am counting how many fields there are each week. So in week 20, there would have been say 3200 duplicates, whereas in week 21 there would have been 3400 duplicates. I expect a slight increase each week.