# Link Jira Origanizations to geolocations **URL:** \ **Category:** Questions & Answers\ **Tags:** map-chart\ **Created:** [November 23, 2020, 10:17pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673 "2020-11-23T22:17:34Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![MarkWheeler](https://community.eazybi.com/user_avatar/community.eazybi.com/markwheeler/32/3909_2.png) [@MarkWheeler](https://community.eazybi.com/u/MarkWheeler)\ **Post date:** [November 23, 2020, 10:17pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/1 "2020-11-23T22:17:34Z")
I’d love to map Jira data based on the associated geolocation of an Organisation. I don’t want to duplicate the geolocation data for an Organization, so is there a way to set this geolocation data in a spreadsheet, import that into EazyBi and use that geolocation data to map Jira issues based on the Organization of an issue? Many thanks in advance Mark ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [December 7, 2020, 10:15am UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/2 "2020-12-07T10:15:02Z")
Hi @MarkWheeler, Yes, you can represent Jira issues based on Organization geolocation. Import **latitude** and **longitude** coordinates for each Organization as **properties**. And then, you can show issues by organizations on the **dynamic Map chart**. For example, if the Organization is a single-select custom field in Jira and you have information on each organization location in jira or some other system. 1. In eazyBI **advanced settings** , define to import the custom field “Organization” in a separate table. The code might look like this, where NNNNN is a custom field ID in Jira: 2. Perform **double data import** to ensure the Organization is correctly imported. 3. Import geolocation of each Organization with **additional data import**. The data source should contain three columns: 4. In the report, set dimension “Organization” on report rows. And select custom properties latitude and longitude as the first columns in the report. And the measure representing issues should follow as the 3rd column. 5. Switch to the **Map chart** and select **OpenStreetMap**. More details on Map charts are here: [https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-charts#Createcharts-Dynamicmap](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-charts#Createcharts-Dynamicmap). And here, you can check out an example of a dynamic map chart: [https://eazybi.com/accounts/26241/cubes/AirportData/reports/180162-dynamic-map-chart-world-airports](https://eazybi.com/accounts/26241/cubes/AirportData/reports/180162-dynamic-map-chart-world-airports). Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) ---
**Author:** ![MarkWheeler](https://community.eazybi.com/user_avatar/community.eazybi.com/markwheeler/32/3909_2.png) [@MarkWheeler](https://community.eazybi.com/u/MarkWheeler)\ **Post date:** [January 21, 2021, 8:49pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/3 "2021-01-21T20:49:23Z")
I’ve tried this various ways. Stopped and come back to it but keep getting stuck on the import. I get a message saying: **Mapping validation errors** Dimension “Organizations” for “Organizations” is not available for import Dimension “Organizations” for “Latitude” is not available for import Dimension “Organizations” for “Longitude” is not available for import ![image](https://community.eazybi.com/uploads/default/original/2X/7/72e4130209fbd2724adafd14884c9f6ef321f5c1.png) The “Organizations” field is a Dimension which is created by Jira Service Desk I believe. I created the separate table for Organizations based on the advice given. Any suggestions or highlight my mistake(s) would be gratefully received. Of all the charts I’ve shown my senior stakeholders so far the map function is their favourite, so keen to get this working. Thanks Mark ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [January 22, 2021, 4:32pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/4 "2021-01-22T16:32:06Z")
Hi @MarkWheeler, My example was based on a single select custom field therefor it worked. On the other hand, the service desk custom field “Organization” is a **multi-selection field** and additional data import is not supported, unfortunately. Therefore data import fails as it is not supported. If you have a relatively small amount of organizations, then you may try another approach to show Organization latitude and longitude in the report. 1. Define a new **calculated measure** in Measures **“Organization latitude”** to show the latitude coordinates based on the Organisation name on report rows. For the calculation use condition CASE WHEN organization name is A THEN latitude is X1 WHEN name is B THEN latitude is X2 END. The expression might look like this: 2. Define another calculated measure **“Organization longitude”** using a similar formula with longitude values. 3. In the report, set dimension “Organization” on report rows. And select calculated measures for latitude and longitude as the first columns in the report. And the measure representing issues should follow as the 3rd column. Best, Zane / [support@eazyBI.com](mailto:support@eazyBI.com) ---
**Author:** ![MarkWheeler](https://community.eazybi.com/user_avatar/community.eazybi.com/markwheeler/32/3909_2.png) [@MarkWheeler](https://community.eazybi.com/u/MarkWheeler)\ **Post date:** [January 25, 2021, 3:26pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/5 "2021-01-25T15:26:02Z")
Hi @zane.baranovska Your solution is brilliant and works fantastically. We don’t have too many organizations so the calculated measure is manageable. You have made my day! Many thanks Mark ---
**Author:** ![Deepak](https://community.eazybi.com/user_avatar/community.eazybi.com/deepak/32/13418_2.png) [@Deepak](https://community.eazybi.com/u/Deepak)\ **Post date:** [October 27, 2022, 6:24pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/6 "2022-10-27T18:24:34Z")
> [@zane.baranovska](#): > > set dimension “Organization” on report rows. And select custom properties latitude and longitude as the first columns in the report. And the measure representing issues shoul @zane.baranovska I read above solution. I already have dimenstion and I try to upload Latitude and Longitude data for it . excel import was successful and I can see both new property were created but my tablet is still empty for Latitude and longitude column. Any suggestion please? ![image](https://community.eazybi.com/uploads/default/original/2X/d/d9a49a3b6acb80de6943b705ba3aa0963b9a0a43.png) ---
**Author:** ![Deepak](https://community.eazybi.com/user_avatar/community.eazybi.com/deepak/32/13418_2.png) [@Deepak](https://community.eazybi.com/u/Deepak)\ **Post date:** [October 27, 2022, 6:45pm UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/7 "2022-10-27T18:45:50Z")
> [@zane.baranovska](#): > > And the measure representing issues should follow as the 3rd column. @zane.baranovska I have fixed it and working now. I had to map it with Key value. Now My question is can I do similar thing with Static map? ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [October 28, 2022, 9:00am UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/8 "2022-10-28T09:00:54Z")
@Deepak This approach won’t work for Static maps. Static maps use dimension member names to represent data but epic names consist of issue key and country code. Regarding data mapping, no data is imported in eazyBI because the first column contains the epic key and name. You might want to adjust the source file and keep the **epic key only** for the first column. This way eazyBI can find epics by their keys and import the coordinates. ---
**Author:** ![Mariana.Silveira.S](https://community.eazybi.com/user_avatar/community.eazybi.com/mariana.silveira.s/32/9914_2.png) [@Mariana.Silveira.S](https://community.eazybi.com/u/Mariana.Silveira.S)\ **Post date:** [June 22, 2023, 12:17am UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/9 "2023-06-22T00:17:06Z")
Hi! @zane.baranovska I had set the latitude and longitude and my table is ok but in the map it showing the wrong location. I’ve checked coordinates are right. Can someone help me with that? Thank you so much! ![Screenshot at Jun 21 21-16-24](https://community.eazybi.com/uploads/default/original/2X/d/dbe23238db249653c5a3b59f14ad2afbbdb5dbed.png) ![Screenshot at Jun 21 21-16-38](https://community.eazybi.com/uploads/default/original/2X/c/c5e734c761f3cef600957d8cd5a5a1836eb4f2eb.png) ---
**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\ **Post date:** [June 22, 2023, 6:22am UTC](https://community.eazybi.com/t/link-jira-origanizations-to-geolocations/5673/10 "2023-06-22T06:22:19Z")
Hi @Mariana.Silveira.S, For the OpenStreetMap chart, the **column order** is important. You might want to switch columns with places so that the first column is **latitude** , then follows **longitude** , and only then the rest of the columns (see also documentation on Map charts: [Create charts](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-charts#Createcharts-Dynamicmap)). Best, Zane / [support@eazybi.com](mailto:support@eazybi.com)