Time to close for current year

Hi there,

I currently have a time to close measure that looks like:

CASE WHEN [Measures].[Issues closed] >0
THEN
([Measures].[Total closing days]/7)/ [Measures].[Issues closed]
END

I am trying to update this measure to include another restriction that only takes into account issues created from the beginning of the year, any help would be appreciated.

Hi @dcachia,
If you want to include some other restrictions in your measure, you will need to filter your issues with those conditions by using filter() and descendants() functions.
In eazyBI demo we have a report that uses similar criteria “Issues created and resolved in period” - it checks if the issue was created and also resolved in the same time period: Issues created and resolved in period % - Issues - Jira Demo - eazyBI

best,
Gerda // support@eazyBI.com

Thank you @gerda.zandersone for the resources! This should help me out

1 Like