Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
Thanks, that was the problem!