Create new measure for closed tickets in sprints without any time logged

Questions & Answers
1

Hello,
can you please assist me on creating a measure “Issues closed without time logged” which does show the number of closed issues per sprint on which there is no time logged.
I would like to enhance our existing report which does show the number of closed issues and the total time of spent on these issues. Unfortunately we usually have couple of tickets for which there is no time logged, so the total hours spend is misleading.

image
image614×608 25.5 KB

Many thanks
Christian

2

Hi @Christian1,

Out of the box, there is a measure “Issue with hours spent” showing how many issues have worklogs.
This measure will identify all issues with logged hours regardless if it is closed or not.

However, to get the opposite (no logged hours) and with additional criteria that issue is closed, you might want to define a new calculated measure.
The calculation would go through all issues and check if it is closed and has any logged hours. The expression might look like this:

NonZero(Count(
  --set of issues matching filter criteria
  Filter(
    --go though individual issues
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    --check that issue is closed
    NOT IsEmpty([Issue].CurrentMember.Get('Closed at')) AND
    [Measures].[Issues closed] > 0 AND
    --there is no logged hours
    IsEmpty([Measures].[Hours spent])
  )
))

For more details on calculated measures, see in the documentation: Calculated measures - eazyBI for Jira).

Best,
Zane / support@eazyBI.com

1 Like