Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

TreeMap sorted by Words

Hello Comunnity, I have a doubt about the Treemap Filter. I need to sort it by words, so in my case, I need the word "YES" to be in the left and the word "NO" to be in the right:   ¿Do you kn...
Need Help
  • Seanan's avatar
    Seanan
    4 years ago

    Hi Anonymous,

    This may not be the best way to get the result you are looking for but I tend to find sorting in a treemap can be a bit of a pain. 

    But a quick way to get it to show Yes then No would be to transform the yes or no column.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    If you replace all of the Yes values with a space in front of it then it will sort the treemap with yes then no.

     

     

     

    As I said this is by no means the cleanest option and it may not be a viable option depending on how your report looks but I hope this may be able to help if there are no better alternatives.

Seanan's avatar
Seanan
Solution Supplier
4 years ago

Hi Anonymous,

This may not be the best way to get the result you are looking for but I tend to find sorting in a treemap can be a bit of a pain. 

But a quick way to get it to show Yes then No would be to transform the yes or no column.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

If you replace all of the Yes values with a space in front of it then it will sort the treemap with yes then no.

 

 

 

As I said this is by no means the cleanest option and it may not be a viable option depending on how your report looks but I hope this may be able to help if there are no better alternatives.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you Seanan!! It worked 🙂