Forum Discussion

Ajwestergren's avatar
Ajwestergren
New Member
8 years ago
Solved

maps - thamatic ranges

I have created a map with production volumes but I don't see where to set the ranges for my thematics. Currently it is giving me a different colored dot for each location. Can someone tell me where you set the ranges?

  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Ajwestergren,

    For your requirement, please create a calculated column using the similar formula like the following 

    NewValue=IF(Table[Amount]<=100,1,IF(Table[Amount]<=500,2,3))

    Then add the 'NewValue' as size level instead of your resource table, then size of farms with <=100 production amount are smallest, then size of farms with 100-500 production amount are bigger, size of farms with >=500 production amount are biggest.

    Best Regards,
    Angelia 

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi Ajwestergren,

    Which map do you use? Could you please share a screenshot for further analysis? I create a general map as follows. The year sales(highlighted in yellow background) is bigger, the size of the dot is bigger. What's your meaning of the ranges? Please share more details, so that we can post solution which is close to your requirement.



    Best Regards,
    Angelia

    • Ajwestergren's avatar
      Ajwestergren
      New Member

      I have dairy farms that produce milk and I want to show the amount produced by ranges 100-500 lbs, 500-100 lbs represented by different sized points. I have gotten it to the point for the inserted resultsbut can it get to this type of result?

      I am using the map feature not the ArcGIS

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee

        Hi Ajwestergren,

        For your requirement, please create a calculated column using the similar formula like the following 

        NewValue=IF(Table[Amount]<=100,1,IF(Table[Amount]<=500,2,3))

        Then add the 'NewValue' as size level instead of your resource table, then size of farms with <=100 production amount are smallest, then size of farms with 100-500 production amount are bigger, size of farms with >=500 production amount are biggest.

        Best Regards,
        Angelia