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
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
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
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.