Working with parent link status

Questions & Answers
1

Is there a way to build a table that contains all the open subtasks with cancelled parents?

2

Hi @pgordalina,

In eazyBI, there is option to create new dimensions that group data by parent issue fields. Those are called link field dimensions in eazyBI.

  1. In eazyBI advanced settings, add code to create a new dimension, “Parent Status”

    [[jira.issue_link_field_dimensions]]
name = "Parent Status"
source_dimension = "Status"
issue_id_column = "subtask_parent_id"
group = "Linked issue dimensions"

  2. Go to import options, tab “Additional options” and select the new dimension for data import.

  3. When data are imported, proceed with the report. Use the new dimension “Parent Status” to filter subtasks by parent issue status. On report columns, select measure “Open issues” and “Issue Type” dimension to show only open sub-task issues. The report might look like in the picture below.

    Open sub-tasks by parent status
    Open sub-tasks by parent status2060×782 91.6 KB

For more details and examples, see the documentation: More details and examples are described in the documentation: Issue link field dimensions.

Best,
Zane / support@eazyBI.com