Eazybi - Average Days in Current Status filtered for only issues created in current Year

[Alex Tremain]

Hi Everyone,

I'm new to EazyBI, and while I've poured through all the suggested documentation, I can't seem to wrap my head around what should be a straight forward metric.

I want to show the Average # of Days an issue has been in its current status, but I only want to include issues which were created in 2019.

I have separate Calculated Measures for "Average Days in Current Status" and "Issues Created in 2019", but I don't know how to take the final step of combining them.

Any help is appreciated. Thank you!

[Ilze Leite-Apine - eazyBI]

Hi, 

To get issue days in current status in the issue level, you may use a calculation between last status updated date (issue property) and now:

DateDiffDays([Measures].[Issue status updated date], Now())

To get the average of issues created in a specific year, you may want to iterate over issues created in the selected time period and then calculate the average of the given above expression:

Avg(
--set of all issues created during the selected time period
 Filter(
   Descendants([Issue].CurrentMember, [Issue].[Issue]),
   DateInPeriod([Issue].CurrentMember.get("Created at"),
      [Time].CurrenthierarchyMember)
   and
   [Measures].[Issues created] > 0 ),
--calculation of days in the current status
 DateDiffDays([Measures].[Issue status updated date], Now()) 
)

Add Time dimension in Pages and select 2019. 

You may use the exact time period (2019) directly in the calculation formula instead of [Time].CurrenthierarchyMember, but then the measure would be less universal.

Ilze, eazyBI support

support@eazybi.com