Link Jira Origanizations to geolocations

[MarkWheeler]

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

[zane.baranovska]

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:

   [jira.customfield_NNNNN]
   separate_table = true
   

   There are more details on where to find and how to set advanced settings: https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields.

2. Perform double data import to ensure the Organization is correctly imported.

   First, in the import option, deselect custom fields “Organization” from data import and import data. This action will clear the previous data and data structures. Wait for data import to complete. Then select the custom field “Organization” for data import and import data for the second time.

   The first two steps ensure that you can import additional data (latitude and longitude) to the Organization.

3. Import geolocation of each Organization with additional data import . The data source should contain three columns:

   • Organization name as you see it in eazyBI. Map this column to the dimension Organization, level Organization. In advanced options, mark to “Skip missing”.
   • Latitude of geolocation. Map this column to the dimension Organization, level Organization, but in advanced options, enter the property name “Latitude”.
   • Longitude of geolocation. Map this column to the dimension Organization, level Organization, but in advanced options, enter the property name “Longitude”.
   

   More details on additional data import here: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/additional-data-import-into-jira-issues-cube.

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.
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.

Best,
Zane / support@eazyBI.com

[MarkWheeler]

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

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

[zane.baranovska]

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:

   CASE [Organizations].CurrentMember.Name
     WHEN "Big Blue Planet" THEN 45.7198
     WHEN "Men in Black (MIB)" THEN 48.3540
     WHEN "UFO" THEN 59.9311
     WHEN "Milky Way" THEN 56.9231
     WHEN "The Restaurant at the End of the Universe" THEN 52.1700
   END
   

   There are more details on CASE WHEN … THEN condition: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Conditions

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

[MarkWheeler]

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