Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data sorting in table matrices

Hi all,

 

I have a small query, I have two columns in a table visulaization column A & column B I have sorted the data in ascending order as per column A. However as we can see in the screenshot in the range 105 & 109 are not arranged in ascending order they should be at the end however as we can see it's in middle can someone help me this. I need to sort this data in ascending order.

Help would be much appreciated.

 

Thanks !

Need Help
Show and Tell
  • Smalfly's avatar
    Smalfly
    4 years ago

    Hi Anonymous 

     

    This is probably due to the data type of the data in 'column A'.

    Can you try to convert your text to a number format?

     

    This can be done through transform data (then the format will be changed in the entire report) of with a value function (just for this visual).

1 Reply

  • Smalfly's avatar
    Smalfly
    Icon for Responsive Resident rankResponsive Resident
    4 years ago

    Hi Anonymous 

     

    This is probably due to the data type of the data in 'column A'.

    Can you try to convert your text to a number format?

     

    This can be done through transform data (then the format will be changed in the entire report) of with a value function (just for this visual).