Q. how we can Concat latitude and longitude and get data in form of { latitude; longitude } in Gooddata

Hi Gaurav, our Geo Charts are one of the many useful Insights offered in the GoodData Analytical Designer. Through the use of latitude/longitude Geo Pushpins, users are able to aggregate numeric fields around different geographic locations. Please see the following articles which will help you with this: https://www.gooddata.com/blog/using-geo-charts-gooddata-technical-overview/ https://community.gooddata.com/dashboards-and-reports-kb-articles-42/how-to-make-a-geo-chart-144

Hello @Gaurav Tiwari, GoodData does not currently support this type of transformation in the product itself. I would propose to solve it as described in the articles above - on ETL/DB level, e.g. by creating a view on top of your table.

SELECT CONCAT(LATITUDE, ';', LONGITUDE) AS LOCATION FROM customer;