Forum Discussion

intrasight's avatar
intrasight
Icon for Helper IV rankHelper IV
9 years ago
Solved

sorting problem/question

I have a table visual. I have a text field in the first column and a number field in the second column. I want the table sorted by the first column alphabetically and then by the second column numeri...
Need Help
  • intrasight's avatar
    intrasight
    9 years ago

    I effectively did that. I added two new entries into the existing Table.TransformColumnTypes. I don't get why it doesn't do that automagically. More specifically, if the underlying "Transform file from X" query makes it numeric, why does the final table have the type as "any".  And even the underlying query makes the numeric a decimal whereas clearly it should be integer.   I'll report these as bugs through the correct channels.

Dog's avatar
Dog
Icon for Responsive Resident rankResponsive Resident
9 years ago

Hi intrasight

 

it sounds like you just need to adjust the column format to that of a number type. 

the visuals tend to feed of that information. 

 

D

  • VP's avatar
    VP
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    Go to Edit query and change second colome type to numeric.

  • intrasight's avatar
    intrasight
    Icon for Helper IV rankHelper IV
    9 years ago

    I effectively did that. I added two new entries into the existing Table.TransformColumnTypes. I don't get why it doesn't do that automagically. More specifically, if the underlying "Transform file from X" query makes it numeric, why does the final table have the type as "any".  And even the underlying query makes the numeric a decimal whereas clearly it should be integer.   I'll report these as bugs through the correct channels.