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.
Dog
Responsive Resident
Responsive ResidentHi 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
Most Valuable Professional
Most Valuable ProfessionalGo to Edit query and change second colome type to numeric.