Build custom metrics from my Jira with EazyBI

Questions & Answers
1

Hi,

I am new to EazyBi and Jira.

I have created a project with some custom fields “Planned Start Date”. I want to generate a report for all the sub tasks of my resolved Stories/Bug with following columns.

  1. Issue Key
  2. Issue Summary
  3. Parent Key
  4. Parent Summary
  5. Planned Start Date (A custom Field)
  6. Due Date
  7. Date when the issue was moved from To do to In progress for first time
  8. Resolved Date
  9. Cumulative Hours spent

Can you please suggest how we can put conditions for column 6 and probable definition to be followed for above need?

2

Hi @Bhashyam_Ttv,

I understand you want to show a list of sub-task issues with descriptive information and filter data by Parent issue type (Story or Bug) and status (resolved issues).

  1. To ensure the correct data filtering, import new dimensions “Parent Status” and “Parent Issue Type”.
    You can do this by adding new advanced settings in eazyBI.

    [[jira.issue_link_field_dimensions]]
name = "Parent Status"
source_dimension = "Status"
issue_key_column = "subtask_parent_key"
group = "Linked issue dimensions"

[[jira.issue_link_field_dimensions]]
name = "Parent Issue Type"
source_dimension = "Issue Type"
issue_key_column = "subtask_parent_key"
group = "Linked issue dimensions"

    More details here: Issue link field dimensions

  2. Import the custom field “Planned Start Date” as a property and measure.
    Jira custom fields

  3. On rows, set the “Issue” dimension. Select the Sub-task level from the Sub-task hierarchy.

  4. On columns, select the required details on each sub-task. Select issue properties describing sub-tasks, “Issue Planned Start Date”, “Issue due date”, “Issue resolution date”, and “Issue Hours spent”.

  5. In Measures, create new calcauted measure to show parent issue properties, key and summary

    [Issue].CurrentHierarchyMember.Parent.GetCaption`

  6. In Measures, create another calculated measure to show the date when the issue moved from To Do to In Progress for the firt time. For the calculation, use a tuple of measure “Transition to status first date” and dimension “Transition”:

    ([Measures].[Transition to status first date],
[Transition].[To Do => In Progress],
[Time].CurrentHierarchy.DefaultMember)

    Set measure formatting to Date.
    More details on calculated measures and tuple expressions are described in the documentation: Calculated measures.

The report might look like in the picture below:

eazyBI Sub-task list with details
eazyBI Sub-task list with details1920×887 171 KB

Here is documentation describing principles how to build an issue list report with details: Project issues with details.

Best,
Zane / support@eazyBI.com