topic Re: Advanced Formatting: Using the Filter function to return population values from identified counties in ArcGIS Dashboards Questions

Advanced Formatting: Using the Filter function to return population values from identified counties

dwold — Mon, 24 Jun 2024 14:29:13 GMT

I am trying to return a sum value of filtered population counts from counties noted in my filter function. I am having issues getting it to display in an indicator widget. See anything I am doing wrong with my code:

var filtered_pop = Filter($datapoint.sum_SUM_Population, 'Name == "Shelby County" || Name == "Tipton County" || Name == "Lauderdale County" || Name == "Dyer County" || Name == "Lake County" || Name == "Obion County" || Name == "Weakley County" || Name == "Gibson County" || Name == "Crockett County" || Name == "Haywood County" || Name == "Fayette County"') return { //textColor:'', //backgroundColor:'', topText: 'Total Population', //topTextColor: '', //topTextOutlineColor: '', topTextMaxSize: 'medium', middleText: filtered_pop, middleTextColor: '', middleTextOutlineColor: '', middleTextMaxSize: 'large', bottomText: '(counties experiencing at least very strong shaking)', //bottomTextColor: '', //bottomTextOutlineColor: '', //bottomTextMaxSize: 'medium', //iconName:'', //iconAlign:'left', //iconColor:'', //iconOutlineColor:'', //noValue:false, //attributes: { // attribute1: '', // attribute2: '' // } }

Re: Advanced Formatting: Using the Filter function to return population values from identified counties

KenBuja — Mon, 24 Jun 2024 14:51:50 GMT

This has a few problem. SQL is picky about quotes, so you'll have to encase the entire thing in double quotes and use single quotes for each item. You have to use a single = sign. And you have to use "or" not "||"

var filtered_pop = Filter($datapoint.sum_SUM_Population, "Name = 'Shelby County' or Name = 'Tipton County' or ..."

However, by using "in", you can make this much easier to read and much shorter.

var filtered_pop = Filter($datapoint.sum_SUM_Population, "Name in ('Shelby County', 'Tipton County', ...)"

Re: Advanced Formatting: Using the Filter function to return population values from identified counties

dwold — Mon, 24 Jun 2024 15:19:36 GMT

@KenBuja thank you!!