Report of a single epic

Questions & Answers
1

Hello,
I would like to build a table in order to show the number of issues “done”, “in progress”, “to do” or “waiting” (this is “status” of my issues) according to a unique epic ticket.

i used the formula below in order to obtain the table you can see below.

problem, the formula check all the tickets of my project… and i would like to only scan the ticket linked to an epic.
How can i do this?
best regards,

easy-bi-epic
easy-bi-epic1037×305 54.3 KB

ed file.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentMember.GetDate('Created at'),
      [Time].CurrentHierarchyMember
    )
    AND
    [Measures].[Issues created]=1
  ),
  CASE
  WHEN [Measures].[Issue status]="Done"
  OR [Measures].[Issue status]="In Progress"
  OR [Measures].[Issue status]="To Do"
  OR [Measures].[Issue status]="Waiting"
  THEN 1
  ELSE 0
  END
)

ny idea to help me
Best regards

2

Hi @clement_dd_64

You can skip using “calculated measures” and stick with the default measure, “issues created”.
Just add the “Issue” dimension to page filters and select the Issue.Epic hierarchy.
When report is filtered by epic, the results will be calcualted for filtered epic and all its children.

Martins /eazyBI support

filter by epics
filter by epics1708×1514 205 KB

3

Hello, thanks for your message!
However, in my eazybi project, when i set [issue] as page, i don’t see any field referenced as “epic”.

I think that i need to import something… I have checked the import jira option and i have only 2 fields which are linked to epic : “epic type” and “epic/theme”.

I am not the administrator of the project. I need to contact him in order to add an import right?
If i am right what is the import i need to reach what i need?

Best regards

4

@clement_dd_64

Make sure that “Epic Link” is imported from the “general” tab in the import options page:

https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-software-custom-fields#JiraSoftwarecustomfields-JiraSoftwarecustomfieldsimport

Martins / eazyBI