Import issue change history

eazyBI allows import and analyze issue change history including:

  • issue status workflow transitions – how many times issues are transitioned to particular workflow status (e.g. how many times issues are reopened) or how long issues stay in particular workflow status (e.g. what is average time of issues staying in open status);
  • how many issues were in a workflow status, or were assigned to assignees, or were in a particular sprint at some historical point in time;
  • how custom field measures or single-value custom dimensions were changed over time

Please, select Import issue change history in Jira data import settings.

With this option selected value change history for Sprint and Assignee dimension are enabled as well. It also should be selected if value change history is enabled for any custom field dimension. 

Historical measures 

If this option is selected then the following additional measures will be available:

Transitions to status

How many times during selected Time dimension period issue has been transitioned to the status that is selected in Transition Status dimension (or only transitions that are selected in Transition dimension). Also, first issue status will be counted in this measure on issue creation date.

If you would like to see a distinct (unique) count of issues for these transitions then use Transitions to status issues count measure from the Distinct issues count measure group.

Transitions from status

How many times during selected Time dimension period issue has been transitioned from the status that is selected in Transition Status dimension to different status (or only transitions that are selected in Transition dimension).

If you would like to see a distinct (unique) count of issues for these transitions then use Transitions from status issues count measure from the Distinct issues count measure group.

Transitions to

Hidden measure.

How many times during selected Time dimension period issue has changes to some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes

If you would like to see a distinct (unique) count of issues for these transitions then use Transitions to issues count measure (hidden measure).

You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only.

Transitions from

Hidden measure.

How many times during selected Time dimension period issue has changes from some value in any default field (Status, Assignee, Sprint, Issue type, Priority, Resolution) or any custom field with enabled value changes

If you would like to see a distinct (unique) count of issues for these transitions then use Transitions from issues count measure (hidden measure).

You could use Transition field dimension (it is a hidden dimension and could be used only in calculated measures) to limit transitions for a particular dimension only.

Days in transition status

Use this measure for individual issues to show how many days issue has stayed in status from Transition status dimension. It is calculated when an issue is transitioned from this status (when the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened.

Use Average days in transition status calculated measure when you are analyzing totals of many issues.

Workdays in transition status
NEW

Similar to Days in transition status but only workdays are calculated according to Time dimension options.

In addition, the following calculated members will be defined:

Issues history

Was called Issues in transition status before eazyBI version 4.1.

How many issues at the end of selected Time dimension period are

  • in status that is selected in Transition Status dimension (calculated as Transitions to status minus Transitions from status from beginning of time until the end of the selected Time period);
  • or with Assignee or within Sprint at the end of the selected Time period;
  • or with custom field dimension member (for which Import changes are selected) at the end of the selected Time period.
Average days in transition status Average days that issue stayed in status that is selected in Transition status dimension. It is calculated when an issue is transitioned from this status (when the the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened.

Average workdays in transition status
NEW

Similar to Average days in transition status but only workdays are calculated according to Time dimension options.
Transition to status first date Shows the date and time when the first transition to the corresponding Transition Status (or the selected Transition) was performed.
Transition to status last date Shows the date and time when the last transition to the corresponding Transition Status (or the selected Transition) was performed.
Transition from status first date Shows the date and time when the first transition from the corresponding Transition Status (or the selected Transition) was performed.
Transition from status last date Shows the date and time when the last transition from the corresponding Transition Status (or the selected Transition) was performed.
Transition to assignee

How many times during selected Time dimension period issue has been assigned to the user selected in Assignee dimension.

Transition from assignee How many times during selected Time dimension period issue has been unassigned from the assignee selected in Assignee dimension.

Custom field measures

Please, select the option import value changes for any custom field in a custom field list to enable value change import for numeric custom field to get additional historical measures:

<custom field> change

Custom field value change(increased or decreased value compared to the previous period) in selected Time dimension period.

Calculated as sum of measures <custom field> added and <custom field> removed.

<custom field> history

Calculated member.

Custom field value in selected Time dimension period.

<custom field> added

Hidden measure that could be used in the calculated measures.

How much value is added during selected Time dimension period.

<custom field> removed

Hidden measure that could be used in the calculated measures.

How much value is removed during selected Time dimension period.

Dimensions 

In addition, the following dimensions will be used:

Transition Status All statuses that appear in workflow transitions (the same statuses as in Status dimension).
Transition All individual transitions with names in the format “From status => To status”.
Transition Author User who performed the transition.
Transition Author Group

Corresponding Jira user groups of transition authors. If a user belongs to several Jira user groups then corresponding measure value will be included for all corresponding user groups in this dimension.

Assignee Issue assignee at the moment when the transition was performed.
Sprint If you import Sprint dimension from Jira Software custom fields then also Sprint changes will be stored and will show the sprint when the transition was performed.
Transition field

Hidden dimension that could be used in the calculated measures to limit changes to particular dimension only.

For example. [Transiton field].[Sprint] will limit changes to Sprints only.

Please remember that Status dimension always shows current issue status and you should use Transition Status dimension with these measures. For example, if you would like to analyze how many times currently closed issues were reopened then select Closed status in Status dimension and Reopened status in Transition Status and use Transitions to status measure.

Custom field dimensions

eazyBI supports value changes import for single value custom field dimensions. Please add additional separate_table and  changes in advanced settings for these custom fields:

[jira.customfield_NNNNN]
data_type = "string"
dimension = true
separate_table = true
changes = true

Use custom field ID instead of NNNNN in the definition above. Add the updated custom field definition to eazyBI advanced settings or ask Jira administrator to do this for you. eazyBI advanced settings are common for all accounts and only Jira administrators have access to the settings.

Open source data Jira import options for edit after changes in advanced settings and select the custom field for import as a dimension, with value changes and run an import. After import historical measures will show historical values over time for this dimension.