First of all, thanks for adding the new Choropleth map visualisation! It looks great and I immediately started thinking of places I’d like to start using it
However, none of the data I want to map is at country level, which appears to be what it currently supports.
It’s great that it has a simple option like country codes for people who don’t have their own polygons stored, but for those of us that have custom polygons in databases it’d be fantastic if we could have the option to use a polygon from a column in the results.
Perhaps if when making the visualisation, the first drop-down was “Polygon source” with options “Country code” and “Column in results”. If ever you wanted, this could then be expanded to also have options such as WOEIDs or even cities as additional simple options, but for me the main thing is definitely custom polygons.
Once you selected “Column in results” the next option would be the data format. I think the minimum options here would need to be GeoJSON and Well Known Text (WKT).
Before the choropleth map was added, i’d requested polygon support for the standard map (What new visualizations would you like to see in Redash?), but I think having this in the choropleth map would be even better for most of the uses I was imagining.