Compare the content of my Structure between two different periods

Question

Hi,

I have a Structure that shows projects grouped by level of maturity (To Do, Doing, Done, KO). These levels are labels added to project EPICs.

I would like to be able to compare between two periods how many projects moved from "To Do" to "Doing", or from "Doing to Done".

Would this be possible in Structure or should I extract Jira raw data and build my viz based on this extract ?

Thank you very much for you help !

Nicholas Ellis _ALM Works_ · Answer

Hi Ben,

There might be some fancy JQL way to identify issues that have had certain labels removed or added, and then you could count them in Structure, but there is not a nice way to do this with Expr formulas at present.

This will be possible once history is available in Expr.

Cheers,
Nick [Tempo /ALM Works]

Benjamin MAUREAU · Answer

Hi Nick,

Thank you very much for your answer.

The point is that in my case, these "status" (To Do, Doing, Done, KO) are labels and not stages of a Jira workflow. Hence, I cannot use the Jira status of the displayed project's EPICs in my formula.

Nicholas Ellis _ALM Works_ · Answer

Hi @Benjamin MAUREAU,

Welcome to the community!

This is how I would go about this.  Here is a formula that counts the recently moved to Done issues:

COUNT{
  IF DAYS_BETWEEN(status_category_changed, now()) < 30 and 
    status_category = "Done" : 1
}

You could do basically the same thing with the in progress or "Doing" status issues.

Cheers,
Nick [Tempo / ALM Works]