Help on backlog report

On 3/17/2010 9:08 AM, littleheartb4u wrote:

Hi,

We are trying to build a backlog report that plots the backlogs over a
period. The criteria we use is, the state is in (New, In Progress,
Triaged, Reopened) .

Considering a workitem passes through all these states on a single
day, like
New->Triaged->In
progress->Resolved->Reopened->In
progress->Resolved.

This will give 5 hits of the same workitem for that day which is not
what we need. Basically, in the above case, we need to have 2 hits ,
one for (New->Triaged->In
progress) and other one for
(Reopened)

I understand, to achieve this we need to use some scripting which I'm
not comfortable with. Any help is appreciated.

Thanks,
Bharath

Hi Bharath,

Sorry for the delay on this one.

When we do backlog-type reports, rather than using the changes table, we
usually use the states table, which gives point-in-time measurements of
the number of work items that satisfy certain criteria. For example,
many of our work item reports plot the number of work items in a
particular state or states (e.g. Open) over time, using sample points
from each snapshot. Is this closer to what you're looking for? Look at
the sample report "Open Work Items by Type" for an example of how we do
this.

james
RTC Reports Team Lead