Avg Days to close ticket

Questions & Answers
1

Hello,
I need help for a formula which I have created. In this formula I need to get data for Avg days took to close the ticket. My formula is generating wrong value. can you please look into my formula and guide me with the changes.

Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
[Measures].[Issues created] > 0
AND
NOT IsEmpty([Issue].[Issue].CurrentHierarchyMember.GetProperty(‘Closed at’))
),
DateDiffDays(
[Issue].[Issue].CurrentHierarchyMember.GetProperty(‘Created at’),
[Issue].[Issue].CurrentHierarchyMember.GetProperty(‘Closed at’)
)
)

2

Can Someone Answer to this question?

3

Hi, @varun

Welcom back to the eazyBI community.

We have a predefined measure “Average closing days”, it calculates the average closing days of closed issues. This measure is available when Closed status are specified in Jira Import Options.

You can configure which statuses are considered closed. Please read more here: Issues closed measure

Kindly,
Ilze