Created and StatusChangedtoUAT

I am looking for a report, where it should show rows as each day, column as
Jira BUG create
Jira BUGs transition moved to UAT status

Hi @Saicharan_Charan_Alu ,

Welcome to eazyBI community!

I recommend adding Issue type dimension in Pages and filtering report by the required Issue Type (Bug).

And then proceed with adding the measure “Issues created” and defining a new measure with the following formula:

([Measures].[Transitions to status],
[Transition Status].[UAT])

Best wishes,
Elita from support@eazybi.com

1 Like

Thank you !. This helped.
But i found another issue - if a bug is moved to UAT 2 times in a single, this is giving two count.
Can you please help how to get count of distinct jiras?
btw i kept rows as time to check on a daily basis how many bugs moved to UAT.

Hi @Saicharan_Charan_Alu

In that case I recommend adjusting the formula and use hidden measure “Transitions to status issues count” - you can learn more about Issue change history measures here Import issue change history

([Measures].[Transitions to status issues count],
[Transition Status].[UAT])

Best wishes,

Elita drom support@eazybi.com

1 Like