Count the number of ticket open in multiple project with a gestion of resolution

Questions & Answers
1

Hello,

I am trying to do a Timeline who returned the number of issues that are open weekly for one or multiple project. And if an issue is create during a week and still open in the next week i want that this ticket i count in the two week.

To precisize, for example :

  • I have 3 week, let’s say that i create 5 issues bind to a project, this issue are open so i count them in the week 1 ( week 1 return 5 )
  • Start of the week 2, i create 2 new issues and my 5 issues from week 1 are not resolved yet so i have a count of 7 issues open during week 2 cause i want that previous created/open issues that are not resolved are still visible from a week to another (week 2 return 7)
  • Start of the week 3, 4 of my issues from the week 2 are now resolved, so the result has to be 3 for this week

I am blocked in that case since 1 week, if you have a solution or some axe to help don’t hesitate it would be super cool,

Thank you in advance :slight_smile:

2

Hi,

Please, use the Open issues standard measure in eazyBI. This measurre should behave precisely as you describe.

Kindly,
Janis eazyBI support

3

Hello,
Is there a way to do the absolute oposit? To separate open issues based on the time the were created. So when I have 5 open issues from week one and two open issues from week two, there will be only 2 issues displayed on the second week insted of 7? What measure should i use?
Thank you in advance for your advice.

4

Hi,

You might need a custom measure for showing the open issues by creation date:

([Measures].[Issues created],
[Resolution].[(unresolved)]

This formula shows the number of unresolved issues that were created in the respective week.

Kindly,

Janis, eazyBI support