Reporting EazyBI on Epics child issues

Stu
Contributor
October 30, 2018

I have a large project in Jira, with many Epics.  Within some of the Epics are their child Issues - mine are called "Ideation" or "Workstream", which also have subtasks.  Some of the Epics don't have child issues in them.

I would like to create a report that shows for a given time period:

  1. Show me a list of Epics with their status and also display the child issues under them, with status
  2. Some Epics don't have child issues.- show these as well.

 

2 answers

2 accepted

3 votes
Answer accepted
Ilze Leite-Apine
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 6, 2018

Hi Stu, 

You may use Issue dimension Epic hierarchy to create such a report. Epic hierarchy appears if you have imported Epic Link in eazyBI.

Use this dimension in the report rows (Epic level members); you can expand those epics to stories (parents) to sub-tasks.
In columns, you may want to use "Issues created" to show all epics as well as issue property "Issue status" to display each issue (epic, story, sub-task) current status.

issue epic hierarchy.png

Hope it would help you to create the report! 

Ilze, support@eazybi.com

Stu
Contributor
November 6, 2018

Hi Ilze,

Thanks for the detailed response.  I'll give it a go and report back.

Thanks

Stu
Contributor
November 7, 2018

thanks it worked

Valerii Sverdlyk
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 4, 2019

hi! How could I unify stories from different projects in this report?

For instance I have 5 stories from project A belonging to epic PHXM-166 and I have 1 story from project B belonging to epic PHXM-166. As a result epic in the table is doubled and stories from different projects are hanging under different entries for the same epic:

https://i.imgur.com/3E0qBqy.png 

Ilze Leite-Apine
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 5, 2019

Hi, 

In the Issue dimension Epic hierarchy, issues primary are grouped by their project. Consequently, the epic is displayed under each project it has at least one linked issue (i.e. linked with the epic link).

Though, you may want to define and import a new custom hierarchy in the Issue dimension to group all issues primary by their epics without projects. Here is an example of how to import such a hierarchy: https://docs.eazybi.com/eazybijira/data-import/advanced-data-import-options/additional-issue-hierarchies#AdditionalIssuehierarchies-Epichierarchywithoutprojects

 

Best,

Ilze, support@eazybi.com

Ofer Cohen June 11, 2022

Hi,
I am new to EasyBI...

How can I remove Sub-Tasks from the above report?

Thanks,

Ofer

Ilze Leite-Apine
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 13, 2022

Hi @Ofer Cohen 

You may want to add, in Pages, the "Issue Type" dimension and select "Issue Types by type" hierarchy, value Standard.

Then values from sub-task issues won't be included in the report at all and, if [nonempty] is enabled, sub-task issues won't be displayed in the report rows.

issue types.png

 

Best, 

Ilze, support@eazybi.com

Like Ofer Cohen likes this
Ofer Cohen August 4, 2022

Thanks!

2 votes
Answer accepted
Ebru Cucen
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 23, 2019

@Ilze Leite-Apine 

Is there a way to display the number of the status on the issues? (My question is similar to this report as it requires fixversion filtering, but I think even for this report to find out how the calculated member would be queried will help a lot) 

https://community.eazybi.com/t/how-do-i-build-a-report-with-an-epic-level-field-as-a-row-dimension-and-a-story-level-field-as-the-column-dimension/359/6

Thank you!

Daina Tupule eazyBI
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2019

You can update the report Ilze made above removing Issue status from Measures. Then add a Status dimesion on Columns. Status dimension will split issues in epic by their status.

You can add Issue Type dimension to Pages and select (filter) which issues should be counted there.

report example.png

 

Daina / support@eazybi.com

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events