Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tornado visualization sort by column not working

I am trying to get the Tornado visualization to sort in order by month as it occurs in the calendar year, but I am unable to do so. I created an index column by number to sort that did not work. I changed the index type to text to sort. that did not work. I used the rank function to create another column to sort. This did not work either. Can someone tell me what I am doing wrong? I am a novice so please don't skip anything in your explanation.DataViz

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I ended up taking everything out and loading it back up as a table. While in table format, I sorted by the "sort order". Then I changed the visualization type back to tornado. When each column was back in its proper place, the sorting held. Thanks!

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    You can achieve this: 

     

    1: Create a conditional coulmn sort month for e.g. if( [month]= "Jan","1", if ([month]= "Feb","2"),0)

    2: Click on month column and in top ribbon you will see sort by column option, please click on sort month
    3: Click on the ellipses (...) on right top of your chart and then you can sort by  Sort order

     

    I hope this will solve the issue.

    Please mark it at solution if your issue gets solved.

     

    Thank you.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you, but that type of sort did not work. I used this method with the column "index sort". Still no change.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I ended up taking everything out and loading it back up as a table. While in table format, I sorted by the "sort order". Then I changed the visualization type back to tornado. When each column was back in its proper place, the sorting held. Thanks!