Sorting arrow confusion in data tables Understanding and choosing column sorting symbol representing ASC/DESC At work we had a discussion about table sorting design used in data tables in our app.
Need help in removing sort arrows (asc and desc) on data tables header row, then when the user click the header column an ascending arrow will appear and of course data will be sorted in asc order
In a sorted table, it’s common to have an up or a down arrow indicating the sort style. However, I’m having some trouble determining which direction the arrow should point. In an ASC sort, characters are sorted 1-9A-Za-z.
sorry the confusion I am not using server side sorting but when the user click the header to sort then the table will recreate again and the sorting is done in java. Once the table created I use datatable but I would like to add the datatable sorting arrows manually.
|Sort Arrow Icons Position — DataTables forums|
|Howto style custom sorting icons — DataTables forums|
Sorting Data Tables. All tables in the 340B application can be sorted to make the data displayed more manageable. The first time you click a column heading, the column will be highlighted and the table will be sorted in ascending order (lowest to highest) based on the values in that column.
Note that data tables typically have more than two columns, but this example is reduced for simplicity. The records in the screenshot are ordered forwards, numerically increasing and from A to Z, on the Department column, and the icon is an “up pointing” arrow.
May 01, 2007 · MAKE TABLE query sorting confusion. Discussion in ‘Microsoft Access Queries’ started by eatc7402 via AccessMonster.com, May 1, The data that results in the table created is NOT SORTED the same as the select query was. Tables don’t really have a sort order. Records are like marbles in a bag.
If your data isn’t already in a table, it’s quick to create a table. This will automatically add the sort arrow at the top of the columns. This will automatically add the sort arrow at the top of the columns.
To represent “sort ascending” (a -> b -> c -> ) , my first sense told me that, I should use ↓ to represent it. This is because if I lay my data. a b c It seems like thing is moving naturally toward downwards. However, for the table header under Windows, the thing I saw is, they are mostly using up arrow.
as·cend (-snd) v. as·cend·ed, as·cend·ing, as·cends
v.intr. To go or move upward; rise. See Synonyms at rise. To slope upward. To rise from a lower level or station; advance: ascended from poverty to great wealth; ascend to the throne. To go back in time or upward in genealogical succession. Hence, the Microsoft Windows version is right in this sense. Ascending should be upwards . In the case of the alphabet, you have to think of it in this sense; A is the beginning of the alphabet and Z is the end. You increase as you move from beginning to end. Same as you do with numbers. 1 through infinity.Beste Antwort · 23An up arrow (upward triangle) is literally smallest at the top, and largest at the bottom! Exactly like Ascending order!! Addendum: This ring-stack children’s toy helps understand how ascending order came to be abstracted to an upward triangle, and descending order to a downward one. The early ‘stacked’ up-arrow is visible in the screenshot from Mac OS 8 (circa 1997) in devios1 ‘s answer.54I think the confusion exists because it is not clear if the column header symbol shows the criterion that is currently used for sorting, or acts like a button that will sort according to the symbol when clicked . Is the column that is clicked on for sorting a button (where we would expect the ‘future’ sorting criterion)? Or is it rather a label (where we would expect the ‘current’ sorting criterion) with the additional functionality that it can be clicked to toggle sorting criteria?10I agree with @SNag on this one in that the sort indicator is not, in actuality, an arrow at all, but rather a visual indicator of the way the list is sorted. To offer further support of this, I present a screenshot from Mac OS 8 (circa 1997) that uses a similar metaphor, but one that is clearly and intentionally differentiated from an arrow: I find the analogy to less-than () to be more appropriate than that of an arrow. In mathematics we write 3 < 6 to represent 3 is less than 6. As I'm sure we all remember the mnemonic device that the small end of the symbol points to the smaller value. Of course if the values were arranged vertically, the smaller end would be at the top: As such, one might consider using a less-than symbol or chevron turned sideways as a more intuitively understandable symbol to represent the order. It works intuitively for text (abc < xyz), numbers (3 yesterday). So in short, try not thinking of it as an arrow pointing in a direction and think of it as a symbol representing order, just like less-than and greater-than. Update: It turns out, coincidentally enough, that the latest version of Mac OS X actually does use a vertical chevron just like I had suggested. I did not realize this when I originally posted the idea. So there you have it. There is some precedent after all.6In my opinion, the fact that it is an arrow, a triangle or a chevron is more up to design. The important fact it is the symbol is the same for all pages and not used for another usage. I personnaly find interesting text + symbol, like5I would say neither the up or down arrow are suitable for this . For people reading from left to right, it is slightly more difficult to ‘read’ a vertically-orientated arrow. There is also the problem of the arrow pointing in direction of the data, which gives the impression of the down arrow meaning ascending. Here are some alternatives which leave no (or less) ambiguity: slanted arrows (‘↗’ for ascending and ‘↘’ for descending); right angle triangle (‘◢’ for ascending’ and ‘◣’ for descending); textual description (‘(A-Z)’ for ascending and ‘(Z-A)’ for descending). (Apologies for the Unicode.)4It would be much simpler to understand if you consider “Where will the first row/element appear?” . If it is on the top, the arrow represents that well.4There is an easy way to remember which way the icon should go for either case.
Ascending starts with an “A” and the icon for ascending is shaped like the “A”. Yes, very “pre-K” but I am a visual person 🙂1For alphabetic data, I think it has always been a mistake to apply the idea of ‘ascending’ and ‘descending’, after all the alphabet is just an arbitrary ordering of the letters. For numeric or datetime data, switching between sorting ascending and descending makes a lot more sense and is actually useful. Why do people sort a table or list based on the alphabet? The answer is usually to aid the user as they laboriously scroll and scan through the list looking for the item that they are interested in. Reverse sorting alphabetically does not make this process any easier. If you reverse sort Z-A, why would you want the ‘Z’ items at top? Alternative solutions such as search and filter are much more useful. So my answer would be not to use an arrow, disable the toggle between A-Z/Z-A on that column, and instead just always sort A-Z any time that column heading is clicked.0
To exclude the first row of data from the sort because it is a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort and then select My data has headers. To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, click Sort & Filter , click Custom Sort , and then clear My data has headers .