EazyBI - Transition from Status A,B,C to Status D

[Routela_ Sanjay]

Hi,
In EazyBI i want to create a report in which i want to track how many tickets were moved to status D from different statuses like A,B,C datewise. Like how many were moved to status D today.
Can anyone suggest any formula that can be useful here?
@eazyBI Support @Zane eazyBI Support 

[Ilze Krauze · Accepted solution]

Hi Routela_ Sanjay,

Thank you for your question!

Here's how to create a report tracking transitions to a specific status:

(1) In Pages add:

• Time dimension (for date filtering)
• Transition Status dimension (to filter target status)

(2) In Rows add the "Transition" dimension, which will show from which status the transition happened.

(3) In Columns add predefined measure(s):

• "Transitions to status" - to count total number of transitions
• "Transitions to status issues count" (under "Distinct issues count" group) - to count unique number of issues that were transitioned

(4) Use "Hide empty" option to remove rows with no transitions.

The report result would look like this:

See more about measures and dimensions in Issue change history documentation.

Let us know if there is anything else we can help you with!

Best,
Ilze / eazyBI support team

[Routela_ Sanjay]

@Ilze Krauze Great, thank you for the direction. I followed the same steps and was trying to tweak it bit. Now i was trying to club the transitions made to QA Stage lets suppose from different statuses in one row, using this manually created transition :



But this is returning me blank row. Is there something i am missing here?

[Ilze Krauze]

Hi Routela_ Sanjay,

It is very likely that Transition member names do not include double quotation marks.

I recommend using autocomplete after typing square brackets; you can browse the entire list or start typing the first few letters to narrow it down.

I hope this helps.

Ilze