Calculate Tasks Where State Reverted

[jacobspacek]

How would you calculate how many stories went back into draft once progressed to a state of Approved by PO?

Example

1) story created with state = "Draft"

2) story state updated = "Awaiting Approval"

3) story state updated = "Approved by PO"

4) story state updated = "Draft"

Goal = report on how many stories went back into draft once progressed to a state of Approved by PO?

While this example is specific my question is aimed at understanding if it is possible to track any tasks that progressed from state1 -> state2 -> state1.

[Dr Atul G- LNG]

Hi @jacobspacek 

You can start with the metrics. You can create a metric for same and track the state on same. Please check OOTB metrics. 

create similar for your table and then you can use this in reporting with Database view. 

[jacobspacek]

Thanks for reply.

I have been reviewing that particular metric all week and have also created a new one for table "rm_story".

My issue is using the metric_instance data to answer the question "how many stories went back into draft once progressed to a state of Approved by PO?"

I am struggling to identify stories that meet the criteria.

Using the metric_instance data I can count and identify stories that

- contained certain states at a certain point in time

- current story state

I am struggling to understand how to identify the stories that shifted from state A->B->A only.

Specifically struggling to understand how to answer that question in a report (like count of distinct stories that meet the criteria).

[Dr Atul G- LNG]

Hi @jacobspacek 

What next , is after metrics, create a Database view of metric and Story table and then use that Db view to create report , I am sure you will get some good results. 

[jacobspacek]

I also conducted this during testing earlier today?

I still don't understand how I can use the DB view to specifically identify stories that went from state a -> state b -> state a?

What does the DB_view allow us to do that the metric_instance table wont?