Issues in X Status by Month

Questions & Answers
1

Hi,

Í´m new to Eazy BI, and need advice on how to get the following metric.

I need to get the number of Issues that transition to a certain state per month. (Testing Completed status)

([Measures].[Transitions to status],
[Transition].[in UAT => Testing Completed])

My problem is that if an issue has made this transition several times, it adds the number of times, and I only need to know the last one.

Should I subtract the number of times it reaches Testing Completed status minus the number it comes out?

2

Hi @dacosta
Welcome to eazyBI community!

You are on the right track - only, instead of Transitions to status, use Transitions to status issues count measure (find in Measures under “Distinct issues count” ).
Read more: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history#Importissuechangehistory-Customfieldmeasures

Best,
Ilze / support@eazybi.com