2 Replies Latest reply on Oct 2, 2018 12:19 AM by Isaac Tong

# Projection to meet goal

Hi,

I track software bugs goal for quality.

Each team is track weekly with the bug backlog.

There is a final goal to meet at a future date.

How can I make a projection if each team will or will not be able to meet their goal?

For example, I have data for 3 week, and total I have 8 weeks to meet the goal of 0:

TeamActual # on Week1Actual # of Week2Actual # of Week3 (current week)Week4Week5Week6Week7Final Goal to meet @ Week8
A10080700
B2015100
C10050200
Total2201451000

How do I show based on the current data trend, team A and B will not meet the goal (bonus: based on the current trend, the forecast of meeting the goal is n weeks)

And Team C based on the current data trend, is going to make the goal with no problem (bonus: based on the current trend, team C will already make the goal in weekN)

The same for Total goal.

_____ Isaac

• ###### 1. Re: Projection to meet goal

Hi Isaac,

I'm not 100% sure of your requirement, but do you have an estimated final goal ? (say 800, 700, etc ?)

Then all you would need is the average of the weeks to date * 8 across each team to calculate the forecasted estimate to compare against.

HTH

Peter

• ###### 2. Re: Projection to meet goal

Thanks Peter.  In my example I was going with the goal of 0 at the end - ie no more bug.  So let’s we are going for the linear projection each week, what’s the best way to show that in tableau visually?  Thx.