I am confused with this report

Questions & Answers
1

Hi everybody!

I hope you can help me — I’m really confused.

Image:

merged
merged1840×2610 229 KB

I’ve created a report, which you can see in the image “Red Frame at the Top.” using the custom MDX shown in “Red Frame in the Middle.” The numbers and data are correct, but the resolution for many issues is wrong. I don’t understand why. For example, GPHPOCLOUD-5480, the second entry in the list, is not in the “Unresolved” resolution—it’s actually “Done/Fixed,” as shown in “Red Frame at the Bottom.”

Additionally, I want to include “Resolution” in Pages so I can filter by “Done/Fixed.” However, it’s displaying incorrectly, preventing filtering. Can anyone explain where I’ve gone wrong?

Thanks & kind regards,
Timm

2

Hi @tflagmeyer,

Welcome to eazyBI Community and thanks for posting your question!

eazyBI considers an issue “resolved” only when it has a resolution date set in Jira. This is independent of the Resolution value (like “Done/Fixed”) - if your Jira workflow doesn’t set a resolution date when moving issues to “Done/Fixed” status, eazyBI won’t recognize these issues as resolved.

I recommend using the Issue Closed date instead. Heres what you should do:

  • Go to your eazyBI import options (General tab)
  • Specify which statuses should be considered as “closed” (e.g., “Done”, “Fixed”, etc.)
  • Use “Issues closed” measure and “Issue closed date” in your reports

Learn more about Issues Closed here - See Issues closed measure documentation

Once you have defined the Closed/Resolved statuses, you can define your measure as follows. Note that in the last line, I have applied DefaultMember for the Time dimension. When DefaultMember is used with dimensions, it will ignore the selected members in the report (in this case Time filter you are using). Learn more about DefaultMember here - DefaultMember

Avg(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue closed date],
      [Time].CurrentHierarchyMember
    )
  ),
  ([Measures].[Days in transition status],
  [Time].CurrentHierarchy.DefaultMember)
)

Best wishes,

Elita from support@eazybi.com

1 Like