Latest Contributions by KenBuja

What you have to do is get the domain's codedValue array and for each item, loop through that array to get the correct domain name. This should work var trees = FeatureSetByName($map, "Trees - Trees"); var countspecies = Intersects(trees, $feature); var stats = Groupby(countspecies, "commonname",[ {name: "total" ,expression: "commonname", statistic: 'COUNT'} ]); var topspecies = Top(OrderBy(Filter(stats, "commonname <> ''"), "total desc"), 3); var result = 'The top species in this tract are:'; var num = 0; var codedValues = Domain(trees, 'commonname').codedValues; for (var item in topspecies){ num++; var num_species = item["total"]; var species_name; for (var i in codedValues){ if (codedValues[i].code == item['commonname']) species_name = codedValues[i].name; } result += TextFormatting.NewLine + num + ". " + " " + species_name + " " + num_species + " " + "planted"; } return result   ... View more

But the Min function will return a 0 if one of the features has a null value. You'd have to do this to ignore either null or 0 values. **Updated to put the IsEmpty and zero checks at the front of the if statement   Expects($feature, 'railroad', 'primary_road', 'secondary_road', 'local_road', 'other_road', 'trail') //field names var fieldList = ['railroad', 'primary_road', 'secondary_road', 'local_road', 'other_road', 'trail'] var minimum = 99999999; var minField; for (var i in fieldList) { if (!IsEmpty($feature[fieldList[i]]) && $feature[fieldList[i]] != 0 && $feature[fieldList[i]] < minimum) { minimum = $feature[fieldList[i]] minField = fieldList[i] } } return minField     ... View more

Here's one way to do it. The variable fieldList (and Expects) contains the names of the fields you are comparing . Expects($feature, 'railroad', 'primary_road', 'secondary_road', 'local_road', 'other_road', 'trail') //field names var fieldList = ['railroad', 'primary_road', 'secondary_road', 'local_road', 'other_road', 'trail'] var minimum = 99999999; var minField; for (var i in fieldList) { if ($feature[fieldList[i]] < minimum) { minimum = $feature[fieldList[i]] minField = fieldList[i] } } return minField       ... View more

The reason you're not getting any results for a name less than four words is that you're using specific index values in the split array that wouldn't exist in lines 4 and 6 for shorter words. This should work regardless of the number of words in the name. The third line will contain anything more than four words.     Var FtName = $feature['Name']; var FtSplit = Split(FtName, ' ') Var Counter = Count(FtSplit) When (Counter < 4, FtName, Counter == 4, Concatenate(Slice(Ftsplit,0, 2), ' ') + TextFormatting.NewLine + Concatenate(Slice(FtSplit, 2, 4), ' '), Concatenate(Slice(Ftsplit,0, 2), ' ') + TextFormatting.NewLine + Concatenate(Slice(FtSplit, 2, 4), ' ') + TextFormatting.NewLine + Concatenate(Slice(FtSplit, 4), ' ') ); ... View more

I left missed the closing parenthesis for the GPS text. Since I can't edit my post, it's updated here IIf (IsEmpty($feature.GPS), `${$feature.Site}: ${$feature.Latitude}, ${$feature.Longitude}`, `${$feature.Site} (${$feature.GPS}): ${$feature.Latitude}, ${$feature.Longitude}` )   ... View more