Get only issues created after 2022 to calculate average resolution workdays

Hello

I created a report to show average resolution workdays by month same this:

But I need to get only issues created after 2022 to get this number

What is the best way to solve this? Thank you very much

Hi @JTejada,

Apply a row filter on your table as follows: Date filters

Regards

Thank you eli_solutions but i need to filter data (issues) included to calculated member “average resolution workdays” not filter de result :frowning:

Can anyone help me please ?

Hi @JTejada

Welcome to the Community! :slight_smile:

The “Average resolution workdays” measure, by default, will return the issues that have been resolved in your selected time period, no matter when they were created.

To display only those issues that have been created this year, you can define a new calculated measure with the following formula:

Avg(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentMember.GetDate('Created at'),
      [Time].[Current year]
    )
  ),
  CASE WHEN [Measures].[Issues resolved] > 0 THEN
    [Measures].[Total resolution workdays] / [Measures].[Issues resolved]
  END
)

This formula calculates the average resolution workdays for issues that have been created this year.
Couple of things to note here:
If an issue is created in Feb and resolved in Apr, the resolution workdays will be counted towards April.
If an issue was created in last Nov, and resolved in Apr, no workdays will be counted.

Let me know if this fits your use case!

Best regards,
Nauris / eazyBI support

Hi @nauris.malitis

Thank you very much. It works !!!