Document toolboxDocument toolbox

Issues closed measure

By default, Jira stores just the issue resolution date (resolved issues are counted in Issues resolved measure) but not the final issue closing date. But frequently, it is important to analyze closed issues (which are in final closed status) and not just resolved issues.

For this purpose, when starting Jira data import in flex.bi plugin, specify the Closed statuses field value. By default, standard Closed status will be selected but if you have custom workflows with different final closed statuses, then specify one or several final closed statuses in this field. If multiple statuses are defined as closed statuses, the closed date would return the last closed status event's date.

Or, if you have selected team-managed projects for data import, make sure to list project-specific statuses as well; status value is a combination of status and project key, like "Done (DEMO)".

If closed statuses are specified, then during Jira issues import issue status change log will be analyzed for closed issues (who are currently in one of the closed statuses), and the last workflow transition to closed status will be found to get the issue closed date.

The following additional measures will be defined:

Issues closedClosed issues that are currently in closed status. Used with Time dimension - grouped by issue closed date (last workflow transition date).
<custom number field> closed

All custom number fields which are imported as measures will also have “… closed” measure created.
E.g., if the Story Points custom field is imported, then also Story Points closed measure will be created.

In addition following calculated measure will be defined:

Issue closed dateIf the Issue dimension is placed on rows and expanded to detailed issues and the Issue closed date is placed on columns, then the issue closed date for detailed issues will be shown. In case multiple statues are defined as closed statuses, this property would return the last closed status date.
Average closing daysCalculates the average closing days of closed issues (by issue closed dates on the Time dimension).
Hidden Total closing days measure that returns the total number of days from created to closed dates is used in the formula.