5 Replies Latest reply: Jul 1, 2015 6:48 AM by sindhu kannan RSS

    color by expression in maps

    vinia marciano

      Hi, Community.

       

      Am having a problem color coding my maps. Here's a sample table:

       

      areacodemagnitudeproportion
      100120.2
      100225.25
      100315.15
      100410.1
      100530.3

       

      I would like the the map to color polygons whose values are less than the average of proportion red and those equal and greater than the average proportion green. This expression in color by expression does not work.

         

           If (proportion < Avg(proportion), Red(), Green())

       

      It just shows all the polygons in green.

      My map and this table are linked by areacode.

       

      Hope you could help me make this work.

       

      Thanks!