Get the number of stories (actually any issuetype) per Epic in a specific status

Questions & Answers
, ,
1

Hello, great community!
I am looking to create two measures.

First need to show how many childrens my Epic have. Using the measurement below I was able to get this information

Count(Childrenset([Issue.Epic].Currentmember))

Second, I need to show which of these children of the epic have the completed status, to have a quantitative view. I was able to get this information but not in the form of a number, but rather the ID of all completed cards, however I need a grouping of these cards, showing how many are completed.

Below is the metric I used to get the information by writing the ID of each card:

Generate(
Filter(
DescendantsSet([Issue.Epic].Currentmember,[Issue.Epic].[Parent]),
[Status].[Status].GetMemberNameByKey(
[Issue.Epic].CurrentMember.get('Status ID')
) = "Done"
),
Cast([Issue.Epic].CurrentMember.key as string),
","
)

Screenshot_4
Screenshot_41666×354 107 KB

If anyone can help me find this information I will be very grateful.

2

If you have at rows every Epic. why don’t you use the “[Measures].[Issues closed]”. It gives you the amount of issues closed by every Epic, because you have the Epic at the rows.

3

Hi @fillipers ,

Instead of using complex filters and generate functions, I suggest a simpler approach:

  1. Use the Issue Epic hierarchy on rows to show epics and their children
  2. For counting completed issues, use a tuple:
([Measures].[Issues resolved], 
[Status].[Done])

This will give you both the total count of children and completed issues in a cleaner way.

For more details on working with Epic hierarchies, see:
See Issue hierarchies documentation

Best regards,
Gerda // support@eazybi.com