It's all about the answers!

Ask a question

Help on backlog report


Bharath M (5465428) | asked Mar 17 '10, 9:07 a.m.
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

One answer



permanent link
James Moody (3.3k24) | answered Mar 26 '10, 11:26 a.m.
JAZZ DEVELOPER
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

Your answer


Register or to post your answer.