Measures and dimensions

On this page:

 
 Video Transcript

In Jira, all data are stored around issues.

The eazyBI data cube is made up of Dimensions and Measures.

During data import to eazyBI, Jira issue information is reorganized and grouped into that structure.

All numerical values like created or resolved issue counts and original estimates are imported as Measures.

Listed values - issue statuses, priorities, users, versions etc - are imported as Dimensions.

All values are also imported as properties for each particular issue.

All dimensions are displayed in a Dimensions area. They are used to analyze measures by different features.

Measures is a specific dimension.

A part of measures is stored during data import based on events happened to issues, like, issue creation, resolution or logged work.

eazyBI is using them to calculate a bunch of other popular metrics, you can use them as well to create your own measures!

Issue properties are specific measures that hold information about each individual issue and is used to display in the issue list.

To create a report, combine Dimensions and Measures.

Measures will be calculated accordingly to each dimension member or combination selected in the report.

Now you know how Jira issue data are restructured in eazyBI dimensions and measures.

Measures

Issues data cube contains the following measures:

Issues createdA total number of created issues that match selected dimension members. If the Time dimension is used then Issues created are grouped by issue creation dates and shown in the corresponding time period.
Issues dueDue (or unresolved) issues that do not have resolution and resolution date. On the Time dimension they are grouped by issue due dates (if issue does not have a due date then it will be counted only in All Times member).
Issues resolvedResolved issues that have resolution and resolution date. On the Time dimension grouped by issue resolution dates.
Issues with due dateAll issues (both due and resolved) which have a due date specified. On the Time dimension grouped by issue due dates.
Issues last updatedA total number of issues that match selected dimension members. If the Time dimension is used then Issues last updated counts issues by last update date and shows total in the corresponding period.
Original estimated hoursTotal of original estimated hours. On the Time dimension grouped by issue creation dates.
Remaining estimated hoursTotal of current remaining estimated hours. On the Time dimension grouped by issue due dates for unresolved issues and by resolution dates for resolved issues.

Hours spent


Total of hours spent on issues matching the selected dimension members. The Logged by dimension can be used to see hours spent by individual users.
 

You can Drill trough cell to get a list of all worklog entries constituting particular Hours spent total value, with additional information -user name, date, issue key, worklog comments, as well as logged hours for this entry. The list could be exported to file.
Sub-tasks created
Sub-tasks due
Sub-tasks resolved
A total number of sub-tasks for parent issues that match selected dimension members.

Read also about additional Issues closed measure and how to use it.

Distinct issues count

Issues created count
Issues due count
Issues resolved count
In Distinct issues count measure group distinct (unique) count of issues is calculated. These measures can show a different result than previously described Issues created, due and resolved measures in a case when some multi-value dimension with a multiple-member selection is put on pages (e.g. Project components or versions or multi-value custom fields). E.g. if several components are selected and one issue belongs to two of selected components then "Issues created" value will be 2 but "Issues created count" value will be 1 for this issue.
Issues with hours spentDistinct count of issues that have any hours logged in the selected Time period.

If Issues closed measure is imported then also Issues closed count will be in this group. If Import issue change history is selected then also Transitions to status issues count and Transitions from status issues count will be in this group.

Calculated measures

The following standard calculated measures are available:

Open issuesCalculates a number of unresolved issues at the end of the corresponding Time dimension period (as Issues created minus Issues resolved since the beginning of the time until the end of the selected time period).
Average resolution daysCalculates average resolution days of resolved issues (that are counted in Issues resolved) and are grouped by issue resolution date on Time dimension.
Hidden Total resolution days Measure, that returns a pre-calculated number of days from created to resolved dates, is used in the Average resolution days formula.

Average resolution workdays

Similar to Average resolution days but only workdays are calculated according to Time dimension options.

Average closing daysCalculates average closing days of closed issues (that are counted in Issues closed) and are grouped by issue closing date on Time dimension.
Hidden Total closing days Measure, that returns a pre-calculated number of days from created to closing dates, is used in the Average closing days formula.
Average age daysCalculates current average age days of unresolved issues (that are counted in Issues due) and are grouped by issue due date on Time dimension.

Average age workdays

Similar to Average age days but only workdays are calculated according to Time dimension options.
Original estimated hours
   with sub-tasks
Remaining estimated hours   
   with sub-tasks
Hours spent with sub-tasks

Similar to Original estimated hoursRemaining estimated hoursHours spent measures but include also estimated and actual hours of sub-tasks of selected issues.

Measures with the suffix "with sub-tasks" should be used only for "Issue" dimension hierarchies with "Sub-task" level members, otherwise, they might mislead you

Properties

Properties are calculated measures retrieving specific information for each particular dimension member. Some of properties are also available as dimensions (Issue Type, Status) to analyze data by or are related to measures (Issues created date is related to measure Issues created or property Issue Story points are related to a measure "Story points created"), while some of them are available only as properties (Project lead).

To get a property value displayed in the report, you should use dimension members of the corresponding dimension in the report rows: Issue dimension Issue level members if issue properties should be displayed, Fix version or Affects version Version level members if version properties should be displayed, etc. 

Property values are displayed empty for higher-level members or if other dimensions are selected in rows. It is also true for calculations where properties are used in the formula.

Property names usually start with the name of the corresponding dimension: Issue .... , Project .... , Version .... .

Issue properties
Issue created date
Issue updated date
Issue resolution date
Issue due date
Issue reporter
Issue assignee
Issue type
Issue priority
Issue status
Issue resolution
If the Issue dimension is placed on rows and expanded to detailed issues and these measures are placed on columns then detailed creation, updated, resolution and due dates, as well as reporter, assignee, type, priority, status and resolution of issues are shown.
Issue parent key
Issue sub-task keys
Issue open sub-task keys
It also can be used if Issue dimension detailed issues are placed in rows.
Other properties
Project lead
Component lead
It can be used if Project dimension (at project or component level) is placed on rows.
Version release dateIt can be used if Affects Version or Fix Version dimensions are placed in rows.

Dimensions

Measures and calculated measures can be analyzed by the following dimensions. Some dimensions contain multiple hierarchies but only one hierarchy from a dimension can be used in the report.

ProjectBoth hierarchies in Project dimension contain a Project-level which can be expanded to the Component level to see all components of the project. If the issue is assigned to several components then it will be counted for each component but only once for the whole project. The secondary hierarchy in the same "Project" dimension which also aggregates projects by Project Category.
ReporterUsers who reported issues.
AssigneeCurrent assignee user for issues.
Issue TypeCurrent issue type.
PriorityCurrent issue priority.
StatusCurrent issue status. This dimension has a secondary hierarchy which aggregates members into Status Category
ResolutionCurrent (last) resolution if present.
Affects VersionThe current affects versions of an issue that are grouped at Project and Status levels. If several affects versions are specified for an issue then it will be counted for all versions but only once for all projects. This dimension has multiple hierarchies to choose from.
Fix VersionCurrent fix versions of an issue that are grouped at Project and Status levels. If several fix versions are specified for an issue then it will be counted for all versions but only once for all projects. This dimension has multiple hierarchies to choose from.
IssueList of all individual issues, grouped by Project hierarchy level. The Issue dimension typically is not used for summary reports but can be used to drill report selected results cell across Issue dimension Issue level to see all individual issues which are counted in some total. This dimension can have more than two hierarchies (for example, if Epic is imported)
It is also possible to establish additional hierarchies in this dimension (if Issue links used in Jira).
Logged byUsers who have logged hours. To be used with the Hours spent measure.
LabelCurrent labels of issue. If several labels are specified for an issue then measures will be counted for each label.
Time

Standard time dimension with Year / Quarter / Month / Day hierarchy and weekly hierarchy with Year / Week / Day levels.

Can enable (add) fiscal time hierarchy with Fiscal year / Fiscal Quarter / Month / Day and define the first month of the fiscal year. Fiscal hierarchy year and quarter member names are referenced by the year in which the fiscal year ends.

Reporter Group

Assignee Group

Logged by Group

Corresponding Jira user groups of reporters, assignees or logged by users. If a user belongs to several Jira user groups then corresponding measure value will be included for all corresponding user groups in the user group dimension.

Age interval

Resolution interval

Corresponding interval dimension of issues age from issue created date till now and for resolved issues by resolution days. Intervals for this dimension can be changed by report users based on their eazyBI user roles.

Calculated members in Time dimension

When you create a new eazyBI account and import data there will be some predefined calculated members created in the Time dimension. These members would be automatically available in Cloud and since server version 5.1

These calculated Time membres can help you with dynamic calculations, for example, to calculate the number of issues resolved in the previous month.

Current monthIt finds and returns the member of the Time dimension at the Month level that is the month when the report is being executed. This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Previous monthIt finds and returns the member of the Time dimension at the Month level that is one month prior to the month when the report is being executed. This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 12 monthsIt aggregates members from Time dimension at the Month level based between 12 months ago and today (dynamically). This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 30 daysIt aggregates members from Time dimension at the Day level based between 30 days ago and today (dynamically). This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 4 weeksIt aggregates members from Time dimension at the Week level based between 4 weeks ago and the current week (dynamically). This member is created in a weekly hierarchy for the Time dimension and might work only in this particular hierarchy.

eazyBI allows opening and viewing formulas for these calculated members but it would not let you change them. Feel free to copy formulas and adjust them to create your own custom periods for report filtering and calculations.