Median Resolution Days grouped by priority - Yearly

Questions & Answers
1

Hello Team
I would like to have a report that would provide Median Resolution days grouped by priority. Please guide me. I am currently not able to group by priority
Thank you

2

Hi SMANDA,
Welcome to the eazyBI community!

Try the following formula for Median (set formatting to decimal):

Median(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue resolution date])),
[Measures].[Total resolution days]
)

If you add a Priority dimension to your report, this calculation will work within each priority.

I hope this helps.

Best,
Ilze