Beast Mode Column Sort Not working Correctly

jtrollinger
jtrollinger Member
in Beast Mode

The Following Beast Mode is reversing 1 & 2 & 4 & 5 for some reason. Only Field in the correct position is Material. I have checked spelling and case of field names.

image.png
image.png

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    The case function is case-sensitive. I will often use the LOWER and TRIM functions around my field and then write the string in lowercase to rule out any case issues the data might have. +1 to @MichelleH suggestions as well.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MichelleH
    MichelleH Coach

    @jtrollinger I would check your sorting settings in Analyzer. If you are sorting by multiple fields, be sure that this is the one at the top of the list. Also, be sure that you are not sorting by the SUM of the sort field.

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    The case function is case-sensitive. I will often use the LOWER and TRIM functions around my field and then write the string in lowercase to rule out any case issues the data might have. +1 to @MichelleH suggestions as well.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories