EazyBI - Report on 'All' transitions

[Kris Dewachter]

Hi All,

We have a Jira workflow with some 'All' transitions (meaning you can transition the issue from all statuses to 1 specific status).

I'm checking to see if it is possible to build an EazyBI report to visualise how many times such an 'All' transition is used. 

In Jira, you can see in this in the transition history of the issue. The transition name contains 'All'.

But I don't see this 'All' mentioned when I use the 'transition' dimension in my EazyBI report.

Does anyone know if this is possible ?

Best regards,

Kris 

[Lauma Cīrule · Accepted solution]

Hi @Kris Dewachter !

eazyBI groups transition in the Transition dimension in "From => To" format, and you can use these together with any transition measures; see https://docs.eazybi.com/eazybi/data-import/data-from-jira/import-issue-change-history#Importissuechangehistory-Measures.

So you could use the Transition dimension to Aggregate(..) from what statuses the issues are transitioning to 'Is klaar voor ontwikkeling' by grouping the transitions (or the other way around; example for calculated member with 'To Do' status)

Aggregate(Filter(
[Transition].[Transition].Members,
[Transition].CurrentMember.Name MATCHES '.*=> To Do'
))

Or you can use the Transition status dimension where you select the Transition and see the count of Transitions to and from status without knowing the exact status issues came from to get into this status.

Let me know if I missed something and if you have further questions!
Lauma / support@eazybi.com

[Kris Dewachter]

Hi @Lauma Cīrule ,

Thanks for your quick feedback.

Actually, I was looking at a way to visualise the 'All' transitions. Ex. When a workflow has an 'All' transition to the 'Done' status, and the user transitions form status 'Demo' directly to 'Done', you can see in the issue history in Jira that this was done via the 'All' transition (see screenshot in my opening post).

But I can not see this 'All' information in EazyBI.

If this information is not available in EazyBI, maybe i can create a report that excludes all the 'normal' workflow transitions (ex. from DEMO to TESTEN BUSINESS.

Best regards,

Kris

[Lauma Cīrule]

Hi @Kris Dewachter ,

I saw your original screenshot, but I thought it was just a visualization, as I cannot reproduce such behavior in my test environment. In the screenshot below - there is no direct transition in my workflow from "In Progress" to "To Do":

But the transition is possible through the "All" transition. Nevertheless, the transition history in Jira does not reflect that the transition happened from "All":

Which environment are you in? Is it a company or team-managed project?

But yes, eazyBI is based on the Jira changelog transition names, and I have not seen that such an 'All' transition would be included in Jira. 

Your idea is correct, though; you could group all transitions Except() the standard ones.

Lauma / support@eazybi.com

[Kris Dewachter]

Hi @Lauma Cīrule ,

It's not a visuaIisation. I am in a Company managed project on a Data Center installation.

I will try creating a report excluding the normal transitions.

Thanks for your assistance. 

Best regards

Kris