Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sort by option not available in line chart

I am trying to show a count of weeks by weeks in descending order.  However, I do not get a sort option in the chart. I need to show the weeks on the x axis in descending order (10 .... 1)  Any help or guidance will be appreciated. Sample Data Images attached.

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous click on the chart and go in the visualization options in x axis, change type from continuous to categorical.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous

    Create a new measure for count of week numbers, then go to modelling tab and choose "sort by" to sort it by the required column,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous

      Thanks for the quick response. I assume you meant a new column measure. Can you give me the exact formula for that column? (eg: week sort = ??) 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I manually added a 2nd column to see if I could force a sort. Sorted week number by sort week. Sorted in different orders but still no luck.