Issue link field dimensions

This page describes advanced JIRA and eazyBI integration. If you need help with this please contact eazyBI support.

Available from the eazyBI Apps version 4.5.4.


On this page:

Overview

Jira Software, Jira Portfolio, issue linking provides an option to build issue hierarchies in Jira and import new hierarchies into eazybi. Different fields could be managed on different hierarchy levels. This section describes an option to analyze data of lower levels, for example, time tracking, story points on stories, sub-tasks by fields on higher levels issues, for example, Epic Fix version. The same option could be used for single linked issue field analysis.

eazyBI supports building new dimensions for some Jira default fields (Fix Version, Label, Status, Resolution, Issue type, Priority) of linked issue, for example, Epic Fix version, Feature Label, etc.

Configuration

If you would like to import linked field dimension into eazyBI you need to add the definition of this linked field dimension to  advanced settings for custom fields.

At first, you need to give a name for this linked issue dimension, for example:

[[jira.issue_link_field_dimensions]]
name = "Epic Fix version"

Then specify which Jira default field should be used, for example:

source_dimension = "Fix Version"

Now, you should set the reference to linked issue custom field

You can use ID column for default field Epic:

issue_id_column = "epic_id"

or key columns for any other custom field describing hierarchy level or one linked issue, for example, if you have custom field_feature with one linked Feature issue, you can use a reference to it:

issue_key_column = "customfield_feature"

then you can set a group in dimension selection:

group = "Linked issue dimensions"

Linked dimensions import and usage

After you have saved the advanced settings with linked field dimension definition then go to the Source Data tab and see if you have this dimension in the list of available linked dimensions in Additional options tab.

Select dimensions you need for data analysis for import in each account.

eazyBI builds link field dimensions with the same structure as default dimensions. They will have the same hierarchies and member structure as default dimensions. eazyBI support access to the same set of properties as default ones as well.

[Epic Fix Version].CurrentHierarchyMember.Get('Start date')

The example formula above retrieves release start date for Epic Fix version dimension members.

Examples

Epic Fix version

[[jira.issue_link_field_dimensions]]
name = "Epic Fix Version"
source_dimension = "Fix Version"
issue_id_column = "epic_id"
group = "Linked issue dimensions"

The example above describes how to analyze stories and sub-tasks based on Epic Fix version.  source_dimension in this case is Fix Version and you can use reserved ID field epic_id in issue_id_column.

Feature Label

If you have a linked Feature grouping your Epics you can define it with Issue link import and then create a new dimension Feature Label enabling data analysis by Feature Labels in Epics, Stories, Sub-tasks:

[jira.customfield_feature]
name = "Feature"
inward_link = "is child of"
issue_type = "Feature"
update_from_issue_key = "epic_key"

[[jira.issue_link_field_dimensions]]
name = "Feature Label"
source_dimension = "Label"
issue_key_column = "customfield_feature"
group = "Linked issue dimensions"

The first definition describes issue link Feature. Then you can use the Feature custom field in issue_key_column as a reference and specify field Label as source_dimension .