topic Color Expression for mapping points not mapping correctly in App Development

Color Expression for mapping points not mapping correctly

Wed, 21 Sep 2016 18:24:19 GMT

I have about 80 points that i'm mapping.

I'm using the expression:

If (CPM<=40.0,RGB(0,254,0),(If(CPM>=100.0,RGB(254,0,0),RGB(0,0,254))))

The value of CPM for just south of Dallas is 35.4 and 35.7 (which has two readings at same geo location), each of those should map as Green, given the expression; however, it's drawn as blue (which is the default). Is it rounding, are there issues with the mapping of color/point/function pairs? It's working correctly on other locations. Open to any ideas to test. - Paul

Re: Color Expression for mapping points not mapping correctly

rittermd — Wed, 21 Sep 2016 19:47:31 GMT

I would break up your expression and test each piece to make sure that it is not a data issue.

Try the CPM<=40.0 and see if the 2 locations near Dallas are green or blue.

Then go from there.

Re: Color Expression for mapping points not mapping correctly

Anonymous — Wed, 21 Sep 2016 20:50:32 GMT

Paul,
If I got you right, you have two CPM values for the same exact location. That means CPM value here is not defined for the purpose of the color expression.
If my assumption is correct, you need to change your dimension. Or, depending on what you need, replace CPM with avg(CPM) in your color expression.

Re: Color Expression for mapping points not mapping correctly

Thu, 22 Sep 2016 20:04:57 GMT

Thanks, that was the problem!