Throughput & Cycle Time Calculator Loses X-Axis values when weeks are skipped
Closed this issue · 2 comments
I just noticed something odd with the WIP Items Per Week chart. It looks like it calculates the x-axis weeks based on the Start Dates. This means that any items that have been finished in weeks after the last item was started don't show up.
I'm tracking features, which tend to be large enough that this is likely!
In your sample data you can replicate this by deleting the start dates B145:B152, so that the last item start date is 08-May-15, but the last completed date is 13-May-15. The x-axis will shrink from week 20 to week 19 and lose the reduction in WIP in week 20.
Make sense?
Altered the calculation in Work in Progress sheet I3- to use the maximum started or completed date. This will extend the axis if a completed item is more than one week after the last started date for long running items.
WAS
=IF(ISNUMBER(I2),IF(I2+7<=MAX(IndirectStartDates),I2+7,""),"")
TO
=IF(ISNUMBER(I2),IF(I2+7<=MAX(IndirectStartDates,IndirectCompletedDates),I2+7,""),"")
Will get it checked by Karl who reported the issue.
Got feedback from Karl this fixed his problem. Will keep an eye out for any further cases.