Resolved date based on the created date

Hi community

I am trying to build a chart that will display the follwing metric on a monthly level
Resolution Time: 85% in 15 calendars days/100% in 45 calendar days
This is what i did so far:

  1. Created two calculated fields to show how many tickets were reolved within 15 days (and 45)
    Screenshot_1

  2. Created a percentage calculated field that devides the field from point 1 by the items created
    Screenshot_2

The problem i have is that an issue is with overlapping monts, meaning, if an issue was created in the end of November let’s say and was solved in the begining of December (meeting the “less than 15 days rule”), the cretaed will be marked in Nov while the reolved is Dec.
This creates some wierd values

Any idea how to improve my data?
Can the cound of the reolved be the created date somehow?

Hi @McKogan,
Welcome to the eazyBI community! :wave:

You can adjust your first formula, so it is grouped on Time dimension by the created date:

    NonZero(
  sum(
    Filter(
      Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    Not IsEmpty([Measures].[Issue closed date])
    AND
    DateDiffDays(
      [Measures].[Issue created date],
      [Measures].[Issue closed date]
    ) <= 15 ),
    [Measures].[Issues created]
  )
)

Then the same grouping is used for your second formula:

With this, you should be able to avoid weird results, but let me know if you still encounter some problems!

best,
Gerda