Scatter Map Color Break By

According to Documentation for Scatter Map widget, in the Color section only a numeric field can be used.

Has anybody managed or found an alternative on how to use a text field instead?

We would like for the Scatter map to be color-coded based on a text field.

eg. If i have stores from Walmart or Costco, to be able to color code them differently. (blue for Walmart stores & red for Costco)

Michalis Gregoriou

Posted 8 months ago·Last reply 7 months ago

5 comments

DRay

·7 months ago

Hello MikeGre,

I’m following up to see if the solution offered by Ido_QBeeQ or TriAnthony worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

DRay

·8 months ago

Hello MikeGre,

I’m following up to see if the solution offered by Ido_QBeeQ or TriAnthony worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

Michalis Gregoriou

OP8 months ago

Hi TriAnthony & Ido_QBeeQ ,

Thanks for your replies!

Ido Darnell

·8 months ago · Edited

Hey MikeGre

You will be able to achieve this by assigning an integer per each store brand, use that int in the color panel and like TriAnthony writes above, use MIN, MAX, or AVG functions on that field in the widget. You can then use a script to modify the legend's and map the INTs to text values of each store.

Another option would be to test out our powerful QBeeQ Super Map plugin which allows to break by points color by text just like in your requirement and much more. We're also working on breaking down the points types by shape so you will be able to plot different layers of points, all in one view.

This plugin is the ultimate map for any Geospatial analytics needs in Sisense. It incldues a territorial layer as well as points , and one can plot both on top of each other. It comes with a wide range of additional features like a robust tooltip, measure switchers, powerful exporting and more as below:

Prebuilt Territorial Polygons: Quickly apply visualizations to pre-configured geographic areas like US states, counties, census tracts, EU countries, and UK regions, saving setup time.
Custom Territories/Data Sets: Use custom geographic regions or datasets to tailor the map to your specific data and analytical needs.
Map Bases: Choose from various map styles (street, bright, dark, satellite) to match your data and presentation preferences.
Customizable Design: Customize polygons and points for clearer data representation and improved map effectiveness.
Multi-Layer Presentation: Overlay multiple data layers to compare and analyze datasets simultaneously, revealing trends without switching between maps.
Interactive Tooltips: Leverage jump-to-dashboard and click-to-filter functionality within tooltips to seamlessly explore data from the map.
Customizable Tooltips: Incorporate relevant and contextual information for each polygon or point at a glance for deeper analysis
Measure Switcher: Toggle between measures for both polygons and points, creating a wide range of mapping combinations
Multi-select Lasso: Select irregular or non-contiguous areas, rather than being limited to predefined regions or boundaries
Export Options: Export maps in multiple formats (PNG, PDF, SVG, JPEG) with customizable layout and resolution for easy sharing and presentation.

Feel free to reach out if you'd like any assistance with that legend script,

If you have any other questions don't hesitate to reach out,

We're always here to help :)

Ido from QBeeQ

QBeeQ - Gold Sisense Partner

info@qbeeq.io

Feel free to subscribe to our newsletter to stay up to date with the latest QBeeQ news

Tri Anthony

·8 months ago

Hi MikeGre,

The Color panel expects an aggregation, so it's not possible to use a text field for it. A simple workaround is to map the text values to numeric codes in the data model and then apply either the MIN, MAX, or AVG functions on that field in the widget.