Forum Discussion
intrasight
Helper IV
Helper IVsorting 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...
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.
Hi intrasight,
As you said, when sorted column is numeric type, the sort function still displayed "Sort ASC/DESC". I think it's a display issue, even if the sorted column is number, the order function also works on it.(perhaps they just forget to dynamic changing display text :smiley happy:)
Regards,
Xiaoxin Sheng