Get the list of Epics and stories under the epics

Questions & Answers
1

Hi,

I am looking to get something like this:
Epics and stories under the epics

image
image.png2458×246 47.8 KB

Please let me know whether its possible.

Thanks
Vas

2

Sorry for the post, I solved it myself.

It was very easy to do it, Just added measures and selected the issue properties. However, I am not able to bring the sprint start date of that particular issue.

image
image.png2472×615 67.1 KB

3

Hi @lauma.cirule

I have the below report and I am trying to generate “past sprints (or completed sprints)” of the issue and start and end date of the sprint for that particular issues, could you please help me with that?

image
image.png2424×860 169 KB

Thanks
Vasanth

4

Hi @vamakam!

Great that you solved the original question. Following are the formulas you are still looking for:

All Issue sprints (this returns value only if Issue dimension and level below Project is selected)

CASE WHEN
  [Issue].CurrentHierarchyMember.Level.Name <> "Project"
THEN
  Generate(
    Filter(
    [Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name <> "(no sprint)" AND
    [Measures].[Transitions to] > 0
    ),
    [Sprint].CurrentMember.Name, ", "
  )
END

Current Sprint start date - we filter Sprint members to find the one that matches Issue current Sprint and get it’s start date

Filter([Sprint].[Sprint].Members,
  [Sprint].CurrentMember.Name <> "(no sprint)" AND
  [Sprint].CurrentMember.Name = 
    [Issue].CurrentHierarchyMember.get('Sprint')
  AND [Measures].[Issues created] > 0
).Item(0).get('Start date')

Current Sprint end date - in a similar way as above, only the property has to be changed to ‘End date’

Filter([Sprint].[Sprint].Members,
  [Sprint].CurrentMember.Name <> "(no sprint)" AND
  [Sprint].CurrentMember.Name = 
    [Issue].CurrentHierarchyMember.get('Sprint')
  AND [Measures].[Issues created] > 0
).Item(0).get('End date')

Lauma / support@eazybi.com

5

Hi @lauma.cirule,

Thank you, it works.

I was also trying to add issue summary with below calculate field
[Issue].[Issue summary]
[Issue].Currenthierarchymember.summary

However, its not working, can you please help me with that as well?

Thanks
Vas

6

The issue summary is part of issue name. It can be displayed by extracting that part of the Issue member name with following formula

CASE WHEN [Issue].CurrentMember.Level IS [Issue].[Issue] THEN
  Mid([Issue].CurrentMember.Name,
Len([Issue].CurrentMember.Key) + 2)
END

Lauma / support@eazybi.com

1 Like