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 ch...
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!

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.