Workdays by issue type

Hello everyone!

I have a question.

We want to make a working day by issue type by year.

  1. open, reopen, In progress Issue type --> Create Date ~ Today Working day
  2. resolved --> Create date ~ resolve date

1+2 = working day by year

How can i make it?

  • Columns : Time (2018, 2019)
  • Rows : Measure

You can try out this formula to calculate an Average of time is open from creation date till today or in how many days issue were resolved for any created issue in a selected period:

NonZero(AVG(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created] > 0),
    CASE 
    WHEN NOT IsEmpty([Measures].[Issue resolution date]) THEN 
    DateDiffWorkdays(
      [Measures].[Issue created date],
      [Measures].[Issue resolution date]
    )    
    ELSE
    DateDiffWorkdays(
      [Measures].[Issue created date],
      Now()
    )
    END
  )
)

If you would like to see this value cumulatively for any period, you can check the measure Average days till resolution or period end in example Average age till resolution report in our demo account.

Daina / support@eazybi.com

I don;t want AVG.
If i delete AVG, An error message appears.

Formula is not valid:
No function matches signature ‘NonZero(, )’

In the formula example, I used an aggregator AVG. You can use any other, for example, Sum, Min, Max, etc., that matches the expression and gives a numeric value as a result.
Function(set, numeric_value)

Please check what functions there work on sets.

Daina / support@eazybi.com