Expression

Question

Hello I am very new to ArcGis Online. I am creating a map with my parcel information that will show what Reval Year that parcel is in 1-5 years, and I need to show when it last last sold based of sale date. I only need for 2023-2027. I am guessing I need to create some type of expression for this, but have no idea why. Any help someone can offer me? Thank you so much!

JANNELLEJENSEN · Answer

I will give this a try. Thank you very much for your assistance with this.

AustinAverill · Answer

You could pretty easily accomplish this using an expression as the "field" you symbolize by in MapViewer. So, instead of selecting a field, click add expression in the symbology pane. Then your expression should look something like this:

//storing the SaleDate value as a variable
var dt = $feature.SaleDate;

//logic to check if field is empty
if(IsNan(dt) || IsEmpty(dt) || dt == null){
    return "No Sale Date Information";
}else{
    //if not empty, gets year value and tests against various logic
    var yr = Year(dt);
    if(yr < 2023){
        //returns a text name for the symbology category produced
        return "Sold Before 2023";
        }else if(yr == 2023){
            return "Sold In 2023";
        }else if(yr == 2024){
            return "Sold In 2024";
        }else if(yr == 2025){
            return "Sold In 2025";
        }else if(yr == 2026){
            return "Sold In 2026";
        }else if(yr == 2027){
            return "Sold In 2027";
        }
}

However, given the data you showed, symbolozing based on SaleDate, you won't have any data points for the "Sold In 2026" or "Sold In 2027" categories for a couple years to come. You can always change the return values to category names you like better and change the data value column to a different one if needed.

JANNELLEJENSEN · Answer

I have my reval areas 1-5 that are outlined in different colors.(see below) I would like to have the parcel that sold a filled in color based off the year it sold 2023-2027. My table data fields I am using is Reval Year & then one is a Sale Date field, which is what I am struggling with. I just want to have a fill color on those polygons. Hope this makes sense. I am very, very new to ESRI and mapping in general, so maybe it isn't something that can even be done. Thanks for your help! 
REVAL AREA COLOR OUTLINEPOP UP already will show the Sales Price and Date when we click to open it.