topic Re: I cannot sort my tables numerically in App Development

I cannot sort my tables numerically

Nemo1 — Fri, 15 Nov 2024 21:03:51 GMT

Hello,

So I have a table with four columns, one of each is %Cost. I want to sort it in a descending way but it is not working out for me and I do not get why.

I go to sorting, I leave all the other columns as "Auto Sorting" and I pick %Cost and I chose Sort numerically, ascending... but nothing happens... what can i do?

thanks

Re: I cannot sort my tables numerically

anat — Sat, 17 Feb 2024 09:58:14 GMT

you can make %Cost as a first field in sorting

Re: I cannot sort my tables numerically

stevedark — Sun, 18 Feb 2024 23:18:33 GMT

Hi,

Is %Cost a dimension or a measure? If it is dimension, would it be better done as a measure and is the column a string rather than a number?

As @anat says, the order of the sorting is important. You can click, hold and drag the fields to change which order they are sorted in. This can be a little fiddly if you have a lot of fields. Auto Sorting does not mean those other columns are not sorted first, just you haven't explicitly specified which order.

End users can also double click column headings to apply a sort. If you do that as an app dev though ensure you edit the table after and save the changes.

Hope that helps,

Steve

Re: I cannot sort my tables numerically

Nemo1 — Mon, 19 Feb 2024 07:28:56 GMT

thanks for your help.. it did work!