Reporting on "Repeat Issues"

Questions & Answers
,
1

I would like to report on the rate of “repeat issues” we receive on a week to week basis in our project. I would like to have a total weekly and monthly count, as well as a timeline view to compare previous time periods.

I’m trying to keep the report simple for now, as the definition of a repeat issue can get complex; below are the criteria for an issue qualifying as a repeat:

  • If the issue is in a closed status
  • If another issue exists that was submitted within 1 week of it, AND said issue has the same customer request type and the same reporter

Thank you!

2

Hi @gophertv ,
You can try this MDX calculation below.
Issues are filtered by:

  • issues are resolved and request type is not ‘(none)’
  • issues with the same reporter and issue type is resolved in the previous corresponding time period (select time weekly hierarchy to see this week by week):
Sum(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Measures].[Issues resolved]>0
    AND
    NOT [Measures].[Issue Request Type] = '(none)'
    AND
    ([Time].CurrentHierarchyMember.PrevMember,
    StrToMember("[Reporter].["||[Reporter].[User].getMemberNameByKey([Issue].CurrentHierarchyMember.get('Reporter name'))||"]"),
    StrToMember("[Request Type].["||([Issue].CurrentHierarchyMember.Get('Request Type'))||"]"),
    [Measures].[Issues resolved],
    [Issue].CurrentHierarchy.DefaultMember)>0
  ),
  [Measures].[Issues resolved]
)

The MDX formula for this type of logic can quickly become heavy and impact your eazyBI performance.
Maybe there is an option to use some scripted field to mark those issues directly in Jira as duplicates and then import only the end value in the eazyBI? Jira calculated and scripted custom fields

best,
Gerda // support@eazybi.com