Tracking Average Resolution Days based on Creation Date

Questions & Answers
1

Hello,

Please see attached picture.

It seems like “Average Resolution Days” and “Average Closing Days” are calculated based on when the issues gets resolved and closed, respectively.

But I was wondering if it’s possible to track this based on “when” the issue got created - not when the issue got resolved. How do I track “Average Resolution Days” for issues created in a particular quarter?

Capture_Avg
Capture_Avg.JPG875×391 11.6 KB

2 Likes
2

Yes, you are right. Average resolution days on the timeline are represented based on issue resolution date, and Average closing days on the timeline are represented based on issue closing date.

To show average resolution days based on issue creation date, you may define a calculated measure in Measures and change the context for resolution days on the timeline using functions Sum(), Descendants() and DefaultMember.

For example, a formula for Average resolution days by creation date may look like this:

Sum(
  Filter(
    -- iterate through created issues with resolution date
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    NOT IsEmpty([Issue].CurrentHierarchyMember.get('Resolved at'))
    AND
    -- measure provides creation date context for timeline
    [Measures].[Issues created] > 0
  ),
  -- average resolution days value ignoring resolution date
  ([Measures].[Average resolution days],
  [Time].DefaultMember)
)

Best,
Zane / support@eazyBI.com

1 Like