Hello there!

I created a chart with Bug inflow, outflow and currently opened bugs (weekly).

I also added linear trends for each metric.

My intention is to create measures to calculate and set:

- To set milestone and limit of amount of opened for this milestone
- To calculate needed outflow (which will be based on currently opened bugs, inflow prediction and limit of amount of opened for milestone) for upcomming time periods (weekly in the future)

I assume for Inflow prediction could be used linear trend for inflow (but maybe somebody can propose better way).

I assume calculation should be based on some ideal outflow and take into account possible changes in inflow.

Simple example to describe my idea:

Case #1 (simple):

- We have 100 opened bugs and all testing activities are finished (inflow = 0)
- We need to fix it till milestone which will happened in 10 weeks.

Decision: we need fix 100/10=10 bugs per week

Case #2 (my):

- We have 100 opened bugs
- We have inflow=10 bugs per week which grows (+2 bugs per week)
- We need to fix it till milestone which will happened in 10 weeks.

Decision: - Find linear trend value for inflow for next week as a prediction
- Add this inflo to ideal outflow for currently opened bugs which is equal 100/10=10 bugs per week
- So outflow for next week should be (10+2)+10 = 22

But how calculate it for several weeks in the future and how to do this with eazyBI, this is a kind of unknown and very hard task for me.

I’ll be appreciated for any help!