topic Re: Sorting in Discussions

Data Table Sorting, Descending

Steven_Moore — Fri, 26 Jan 2018 17:51:20 GMT

I am having an issue with sorting in the Tabulate platform. I create a data table after a simple tabulation. Then, I wish to sort the data by a column (N - the number of items in each category, in this case). However, no matter whether I click the ascending or descending icon, the table sorts in ascending order. Anyone else having this problem?

Re: Sorting

robot — Wed, 19 Oct 2016 00:11:17 GMT

Hi smoore2,

On JMP11, to my knowledge, the tabulate function is not able to directly sort by descending N value. But, by creating a new data table from the tabulated data (using the red triangle), the new data table can be sorted in whatever manner desired.

Re: Sorting

Steven_Moore — Thu, 06 Aug 2015 14:54:30 GMT

Actually, I am having this problem in any platform. I tried an experiment with a new table and mocked up some data to sort. I can only get the sort to work for ascending, not descending. Even if I click the descending icon, the sort is performed ascending,

Re: Sorting

mpb — Thu, 06 Aug 2015 23:27:44 GMT

I'm assuming you are using Tables > Sort on a data table. As long as I remember to select the By variable as entered into the sort dialog before I click the Descending icon I am able to sort descending by that variable. If I forget to do that then clicking the descending icon does not change the sort direction to descending.

Re: Sorting

Steven_Moore — Fri, 07 Aug 2015 17:01:52 GMT

FINALLY figured it out! The default sort is ascending. Once you choose which column to sort by, you then have to select that column within the "by" box and then change the sorting icon from ascending to decending.