2 Replies Latest reply on May 8, 2018 9:19 PM by Manan Younas

    Break Down Data by Spatial File Area code

    Manan Younas

      I have joined 2 data sets.

       

      Data set 1 : Spatial file with Area code SA 2 (  Field : SA2 Main16 )

      Data Set 2 : Businesses data identified by SA2( Field: SA2 Code )

       

      Joined both data sets.

      If I drag SA2Main16 to color Mark, it nicely apply color marking for each SA2 code.

      But If I drag SA2 Code to color mark, it shows null only and do nothing.

       

      Similarly, Any field that I drag from Data Set 2 has no impact on the map. It just shows the values as null.

       

      What I want to find out is , how businesses are spread out by revenue across these Area codes.

       

      Attached is the file