I am using the predefined formula “Average resolution days” to show the average resolution days for all the bugs in my project. However, I want to see this average only for bugs that are created in the last 6 months. How can I modify this formula ?
Current formula i see for “Average resolution days” is
CASE WHEN [Measures].[Issues resolved] > 0 THEN
[Measures].[Total resolution days] / [Measures].[Issues resolved]
I created a calculated member under Time and called it “Last 6 months” and used this formula
But I am not able to figure out how can I get resolution days for only these bugs created for the past 6 months.