Issue Count

[Rjve Nautiyal]

Hi Fidel,

Hope you are doing good.

Do we have any option in JWT which can help me to extract the count of total number of issues in projects based on the issue type.

I am currently looking for the "Test" Issue type.

Thanks & Regards, Rajeev Nautiyal

[Fidel Castro Armario]

Hi @rjvenautiyal,

You can implement it using "Mathematical and date-time expression calculator" post-function for setting a numeric field with any of the following math expressions:

Bugs in current Project

count(issuesFromJQL("issuetype in ('Bug') AND project = " + %{00018}))

Bugs and New Features in current Project

count(issuesFromJQL("issuetype in ('Bug', 'New Features') AND project = " + %{00018}))

Bugs and New Features in project with key CRM

count(issuesFromJQL("issuetype in ('Bug', 'New Features') AND project = CRM"))

[Rjve Nautiyal]

Hi Fidel,

As per the above instruction, I created a field called - Total Number of Test Cases.

So, whenever I am creating test cases, the Total Number of Test Cases are getting added one by one. But that numeric fields will not appear in my dashboard and I need to check which Key is the Last created and then verify the - Total Number of Test Cases field.

My requirement is for one for the metrics and should be able to appear in dashboard- Test Case Productivity = Total Number of Test Cases / Total Number of Person Days.

Is it possible to achieve through JWT.

Thanks & Regards, Rajeev Nautiyal

[Fidel Castro Armario]

Hi @rjvenautiyal,

Sorry, but I'm not completely sure to understand your requirements. Please, try the formulas above in a "Calculated Number Field". This way you will always have the field updated.

Is "Total Number of Person Days" an already existing field? In case it isn't, how do you calculate it?

[Fidel Castro Armario]

Can we close this issue?

[Rjve Nautiyal]

Hi Fidel,

My apologies for delay in response.

We can proceed with closure of the issue.

Thanks & Regards, Rajeev Nautiyal

[Fidel Castro Armario]

Thanks