Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

A list in form of a table can be sorted. One of the columns accepts empty values. If I sort the list by that column ascending, the empty values should be on top or at the bottom of the list? What if I sort it in descending order? Is it appropriate to put empty values always on top or always at the bottom of the list regardless of sorting order?

share|improve this question
add comment

1 Answer

The most natural ordering strategy would be that items with an empty slot are ordered outside the items with filled slots, whether it'd be a descending or ascending list.

For example if you're sorting a list of products on the rate of the product in a descending order then you as a user is not the least interested in seeing the products that aren't rated at all first in the list, but rather last in the list. In that instance the absence of a value makes it non interesting.

Same if you're sorting a list of restaurants on the distance they are from you in an ascending order, then you as a user most probably want the ones with the lowest distance highest up in the list. Items that can't provide a distance from you are not relevant since that is the value you're after.

So to summarize, when ordering on a column in ascending or descending order as a rule you should order the items with an empty value last since they can't provide the user with the value they're after.

share|improve this answer
    
I was thinking about that and it shows that the problem seems highly context sensitive. For example in Windows Explorer MS puts empty values on top of ascending ordered list. In Excel on the other hand, empty values are at the bottom. In examples that you have mentioned, it seems perfectly reasonable to externalize empty values. But what about list of contractors in an accounting application? If some of the records don't have all of the data filled in, isn't it an information in itself? –  Maryh Sep 30 '13 at 13:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.