Hi, I wanted to ask you a question around Locations / Regions / Countries in visualizations. In our datasets we have location name as an attribute of our user table. The location name would be a city. Customers have asked to be able to create visualizations by regions / countries. Is this something we'd need to address by adding these values as separate attributes in the data model, or would there be any other way to achieve this? Thanks in advance

Hi Raffaella, For geographical data we only have Geo Chart (Pushpins) visualization out of the box. More complex visualizations are possible, but these have to be custom tailored and may need some additional development / integrations. To use Geo Chart pushpins you need ot have Latitude and Longitude data in the dataset. Depending on the GoodData product, the format might be slightly different. We have the requirements documented: • GD Cloud: https://www.gooddata.com/docs/cloud/create-visualizations/visualization-types/geo-charts/geo-charts-data/ • GD Platform: https://help.gooddata.com/doc/enterprise/en/dashboards-and-insights/analytical-design[…]/geo-charts-pushpins/configure-data-for-geo-charts-pushpins/ I hope this helps.

Thank you @Boris!

that's exactly right. If you are just looking to enrich the data with Region& Country based on the city - in theory in GoodData cloud the data could be generated using SQL datasets functionality - but I am not sure about the implications on scalability and performance. It's probably better to do this directly in the source database (i.e. in view definition)

Thanks, I will ahve a look