Map Point Layer

CharlieR — Wed, 04 May 2022 10:00:02 GMT

Hi,

I'm trying to create a point layer in maps where it only plots certain points from the data set but struggling to figure out how to do it.

I have an Account Dimension of 40,000 accounts all with an ID and geolocation. But I only want to plot 4,000 of them that are currently active which is defined by a simple flag in the script.

I have tried putting into the Dimension on the point layer =({$<CurrentAccountType={'ActiveSubscriber'}>}Key_AccountID), and also tried putting in the location field ({$<CurrentAccountType={'ActiveSubscriber'}>}GeoLocation), but with both of them it still plots every single account.

I've thought I could add into the script a new field which only gives the geo location or account id where CurrentAccountType=ActiveSubscriber and null the other values, but don't really want to if i can avoid it.

Any ideas please???

Re: Map Point Layer

danielrozental — Thu, 05 May 2022 22:09:05 GMT

If you split you GeoLocation into Lat and Long you can use expressions using set analysis.

max({$<CurrentAccountType={'ActiveSubscriber'}>}Lat) and max({$<CurrentAccountType={'ActiveSubscriber'}>}Long).

Not sure if you can use GeoLocation like that as well.

topic Re: Map Point Layer in App Development

Map Point Layer

Re: Map Point Layer