AnsweredAssumed Answered

Sorting Text Data in Table and Symbology?

Question asked by bhemmer_usfs on May 10, 2019
Latest reply on May 13, 2019 by xander_bakker

This is related to another post I put on here (Better Pop Up Arcade Expression?).

 

My thinking is instead of configuring pop ups with Arcade expressions I would just change the Data Type for my feature class. My original feature class table is set up for numeric values. So I used Feature Class to Feature Class and changed the data type to text. After this I used Calculate Field and applied the following Arcade expression;

if ($feature.Est1 == null) {
    "No observations"
}
else {
    Text(Round(Number($feature.Est1),0),"#,###")
}

 

Worked out just fine. Applied "No observations" to my NULL fields and formatted the numeric text to appear correctly. However, the problem I ran into was when I opened my table and sorted the data the number did not sort like I wanted,

 

Now, I'm sure this is a noob mistake in my thinking so can someone explain where I went wrong? Is there a better way to accomplish a more efficient pop up than using 20 different Arcade expressions. The other trouble I ran into is going this route I cannot apply Graduated Colors to the fields that are text fields. Any help would be appreciated, thank you!

Outcomes