# Average time of resolution without some status

**URL:** <https://community.eazybi.com/t/average-time-of-resolution-without-some-status/1838>\
**Category:** Questions & Answers\
**Created:** [March 11, 2019, 2:02pm UTC](https://community.eazybi.com/t/average-time-of-resolution-without-some-status/1838 "2019-03-11T14:02:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![adllanog](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/59ef9b/32.png) [@adllanog](https://community.eazybi.com/u/adllanog)\
**Post date:** [March 11, 2019, 2:02pm UTC](https://community.eazybi.com/t/average-time-of-resolution-without-some-status/1838/1 "2019-03-11T14:02:58Z")

</div>

Hello  
I need to make a report that calculates the average time until the Issues are in a series of status without taking into account the time they spend in a different series of other status  
Can you tell me how I can get this?  
Thank you in advance.

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [March 13, 2019, 9:42am UTC](https://community.eazybi.com/t/average-time-of-resolution-without-some-status/1838/2 "2019-03-13T09:42:09Z")

</div>

Hi,

In this case, you could create a new calculated member in “Transition Status” dimension to [aggregate](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members#Calculatedmembers-Aggregatemembersinotherdimensions) transition statuses needed for your calculation.

Next, you could enable and select your new **calculated member** in the report.

After that, you could create a new **calculated measure** :

```
[Measures].[Days in transition status] /
[Measures].[Transitions from status issues count]

```

That would calculate the average time (in days) for the transition statuses from the “Transition Status” dimension calculated member.

Martins / eazyBI support