Scatter Map Color Break By

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.

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

 

Hi ​ TriAnthony​  & Ido_QBeeQ​ ,

Thanks for your replies!

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.