Forum Discussion

Espen1515's avatar
Espen1515
Advocate I
8 years ago
Solved

Invert x axis

Hi,   My graph is displaying itself the wrong way around. I want it to be chronological according to date, but instead its counting backwards in time, like this: How can I invert the axis so...
Need Help
  • JoHo_BI's avatar
    JoHo_BI
    8 years ago

    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. 

  • Espen1515's avatar
    Espen1515
    8 years ago

    Alright, I'll try that. Thanks!

JoHo_BI's avatar
JoHo_BI
Responsive Resident
8 years ago

Can you not use the 'sort by' option to sort it by the original date column you extract WEEKNUM and YEAR from? 

Espen1515's avatar
Espen1515
Advocate I
8 years ago

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:

 

 

  • JoHo_BI's avatar
    JoHo_BI
    Responsive Resident
    8 years ago

    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? 

    • Espen1515's avatar
      Espen1515
      Advocate I
      8 years ago

      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.

      • JoHo_BI's avatar
        JoHo_BI
        Responsive Resident
        8 years ago

        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.