topic Re: Selecting map layer data calculated using variables in App Development

Selecting map layer data calculated using variables

JeffMelon — Thu, 19 Jan 2023 19:06:55 GMT

Hi,

Is there a way to select all area locations within a map layer that contains location data calculated through variables/variable input boxes?

The snip below shows a portion of the map I currently have, each different colored area is it's own Area Layer. Each area's color may change as users different values in the input box; users would then like select a colored area, for example "Red", and the map filter for all Red areas, not the individual Red area.

Is this achievable?

Thank You

Jeff Melon

Re: Selecting map layer data calculated using variables

KGalloway — Fri, 20 Jan 2023 20:52:41 GMT

Hi Jeff,

I don't think there is a way to do that in the Map object. You could create buttons that make selections in the field based on the values you've used to define the colors.

For example,

If the user inputs 12 to highlight counties with a value of 12 as red, you could have a button that selects all counties with a value of 12.

If you provide a little more information about the data, I could try to create some sample code that would do this.

Re: Selecting map layer data calculated using variables

JeffMelon — Wed, 25 Jan 2023 13:58:47 GMT

All the areas on the map are zip code locations. What designates their color is two things, one being the result of a few variable stored expressions that rank win/loss/no change for sales performance forecast, two being the values entered in the variable input box for estimated growth and the name.

Re: Selecting map layer data calculated using variables

KGalloway — Wed, 25 Jan 2023 15:34:53 GMT

I think I have a partial solution. The method described below works for me.

1. I created the following test data:

The first three columns are loaded in the load script, but the average values are calculated in the chart.

2. I colored the map based on the average values and the following logic: >6 is red, then >3 is yellow, else is green.

3. Finally, I created 3 buttons that make selections in the Country field when clicked. The key is how the buttons choose to make selections. Set the button function to 'Select values matching search criteria' and set the value to some variation of '("' & concat(if((value1 + value2) / 2 > 3 and (value1 + value2) / 2 <= 6, Country), '"|"') & '")' where the exact conditions of the if statement vary based on which values you want to pick. This example picks RUS.

My example is simple, but I think you may be able to adjust it to fit your needs by replacing the if statement conditions with your specific requirements.

Re: Selecting map layer data calculated using variables

JeffMelon — Fri, 27 Jan 2023 00:32:35 GMT

Thank you, applying that logic and formulas it finally works. Much appreciated!!