There are tables in our app with a sortable position column which contains values between 0 to 50
. Which, in our case, 0
means the item cannot be found.
So the question is, when sorting the column ascending / low to high
, should the 0
values be displayed first or last? Keeping in mind that these 0
values are still important to users as they need to fix them so they'll have a > 0
position.
Also, these positions are not unique, meaning there could be cases where there are > 100
0
values and the users will have to go to the 2nd or 3rd page of the table to see the best positions, which are 1
As for the meaning of the values, they represent the position in search engine results for the keywords that users are tracking for their website. So in our case, 0
means that the user's website doesn't show up in search results for that specific keyword. So users will be more interested in the keywords that have position 1
, 2
or 3
.
Here is the table for a better understanding of my question:
As you can see in the above, the table is sorted asc by position, so what users are really interested in is those keywords that have a > 0
position to see their changes over a period of time.
0
value importance)