# Geospatial Map Question - Comparing

**URL:** <https://community.amazonquick.com/t/geospatial-map-question-comparing/7162>\
**Category:** Q&A\
**Tags:** formatting, quick-sight\
**Created:** [October 27, 2022, 4:40pm UTC](https://community.amazonquick.com/t/geospatial-map-question-comparing/7162 "2022-10-27T16:40:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![willowfae](https://avatars.discourse-cdn.com/v4/letter/w/82dd89/32.png) [@willowfae](https://community.amazonquick.com/u/willowfae)\
**Post date:** [October 27, 2022, 4:40pm UTC](https://community.amazonquick.com/t/geospatial-map-question-comparing/7162/1 "2022-10-27T16:40:57Z")

</div>

Hello,

My stakeholders are hoping to compare conversation rates based on two different vendors in a Geospatial map.

Currently, it’s one color based on total volume within each state.

However, what they are hoping to see is the coloring to be one color for Vendor1 when their conversion for the area is \>2% better than Vendor2 (and another color for Vendor2 when vice versa).

I am not seeing an immediate way to resolve this issue within Quicksight. Any pointers would be appreciated.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [October 27, 2022, 7:46pm UTC](https://community.amazonquick.com/t/geospatial-map-question-comparing/7162/2 "2022-10-27T19:46:35Z")

</div>

I don’t know if this is possible unless you do it in sql.

The reason for this is because you want to aggregate values (conversion rate) and then use that to color the group. You can’t do that in quicksight.

However, if you calculate this conversion rate per client and per state in SQL then return the vendor name if the conversion rate is greater then two over the state then you should be able to just color by that field.