One Table with different issue types and filters

Questions & Answers
1

Hi,

I need to create a report that contains different filters/queries on different issue types:
For example - Show in one table:

  1. Epics that have more than 50 child stories.
  2. Stories that are in progress state more than 10 weeks.
  3. Bugs that are opened more than 1 year.
  4. Other queries like the above.

I know how to create separate reports for the above but the request is to show all in 1 report (not dashboard).

How do I show this in 1 table report?

Thanks,

Ofer

2

Hello @Ofer_Cohen ,
Thanks for reaching out to the eazyBI support!

To create a report that shows Epics with more than 50 child stories, Stories in progress for more than 10 weeks, and Bugs open for more than 1 year in one table, you can follow these steps:

  1. Start with a new table report and add the Issue dimension (Epic hierarchy) to the rows.
  2. Create the following calculated measures:
  • Epics with 50+ stories:
Nonzero(Count(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Measures].[Issue type] = "Epic"
    AND
    -- more than 20 stories:
    ([Measures].[Issues created],
    [Issue.Epic].[Epic].GetMemberByKey([Issue].CurrentHierarchyMember.key),
    [Issue Type].[Story],
    [Issue].DefaultMember)>50
  )
))
  • Stories in progress > 10 weeks
Nonzero(Count(
  Filter(
    DescendantsSet([Issue.Epic].CurrentHierarchyMember, [Issue.Epic].[Parent]),
    ([Measures].[Issues created],
    [Issue Type].[Story],
    [Status].[In Progress])>0
    AND
    Int(
      DateDiffDays(
        [Measures].[Issue status updated date],
        Now()
      ) / 7
    ) > 10
  )
))
  • Bugs open > 1 year
Nonzero(Count(
  Filter(
    DescendantsSet([Issue.Epic].CurrentHierarchyMember, [Issue.Epic].[Parent]),
    ([Measures].[Average age days],
    [Issue Type].[Bug])>365
  )
))
  1. Add these calculated measures to your report columns.

This approach will give you a single table report that includes all the specified measures.

Kindly,
Gerda // support@eazybi.com

1 Like
3

Perfect.
Thank you very much!

1 Like