Alphabetical Sorting Order

What is the exact logic of the alphabetical sorting on fields?  I have a field called advertiser and find that it's sorting by upper case, sentance case then lower case.  Is this what it's doing??  I need it to sort alphabetical regardless of case.


  • Hi @user04669!


    That is likely what's happening here, is that it's sorting cases in addition to alphabeticals. 


    What you can do as a possible fix for this is to create a simple beast mode that looks like this:


    LOWER(`Your Column Here`)


    Then go ahead and sort by the newly created beast mode and see if that fixes the sort issue. 


    Hope this is helpful!

This discussion has been closed.