Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How to color code different GPS coordinates by category?

 

Hi everyone,

 

I am having trouble color coding two GPS coordinate by category.

 

For example, I want the meter GPS coordinate to be red and transformer GPS location to be green on the map. However, when I tried to do that red and green appeared in the same location.

 

Anyone know what is the best solution to this problem?

 

I have attached screen shots below for references.

 

Much appreciated. 

 

 

  • Sean's avatar
    Sean
    10 years ago

    Anonymous You have 2 options => for both you'll need a Column (e.g. Column = 1 and drag it to the size)

     

    For option 1 you'll have to change the aggregation of Lat and Long to Sum or Avg it won't matter

     

    Pictures are pretty self explanatory - let me know if you have any questions.

     

    Hope this helps!

     

    and here's option 2

     

  • Sean's avatar
    Sean
    10 years ago

    I have no way of knowing what your data looks like?

     

    I answered based on the limited data you originally posted - however PBI can in fact plot ALL your data!

     

    And here it is Zoomed

     

     

10 Replies

  • ankitpatira's avatar
    ankitpatira
    Community Champion
    10 years ago

    Anonymous Isn't that is what is happening currently ? You're getting green for one category and red for another. They both appear in same location because you would have same location in your data for both the categories.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      One the map it is not showing correctedly. 

       

      The map should show one GPS coordinate to be red and the other green but instead its showing 50% green and 50% red on the same GPS coordinate.

       

      Hope you can see what is the problem is now.

  • anithat's avatar
    anithat
    Resolver II
    10 years ago

    Hi Anonymous, I agree with Ankit. Please check the data, both transformer and meter coordinates should be pointing to the same location in this case.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      As you can see the meter and transformer is at a different location.

       

       

       

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        Anonymous You have 2 options => for both you'll need a Column (e.g. Column = 1 and drag it to the size)

         

        For option 1 you'll have to change the aggregation of Lat and Long to Sum or Avg it won't matter

         

        Pictures are pretty self explanatory - let me know if you have any questions.

         

        Hope this helps!

         

        and here's option 2

         

  • anithat's avatar
    anithat
    Resolver II
    10 years ago

    Hi Anonymous, After seeing the data and trying it on my PBID, I would suggest to please use the option 2 from Sean's Answer.

     

    Count of ID in the Size tab should do all the trick for you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Actually I did some further testing it seems to not work for multiple coordinates. The coordinate must be aggregated such as using sum or avg which really doesnt make sense.

       

      Therefore, it did not work when I had mutiple coordinates for transformers and meters.

       

       

      • Sean's avatar
        Sean
        Community Champion
        10 years ago

        I have no way of knowing what your data looks like?

         

        I answered based on the limited data you originally posted - however PBI can in fact plot ALL your data!

         

        And here it is Zoomed