Data Gathering Help/ Query Counter Help

[Alex Deihl]

Currently my team is manually counting these fields below for each of the following items below per each Iteration.

Story Pts Planned

Story Pts Accepted

Story Pts not Accepted

# Stories Planned

# Stories Accepted

# Stories not Accepted

Story Pts Added

Story Pts Removed

# Stories Added

# Stories Removed

I have considered using the query counter app, but would like some guidance on how I can achieve these goals. (how to code them)

[Cali McClung]

Hi Alex,
The query counter won't be able to give you any of these counts on Points.  The counter only counts work items: stories, defects, features...
For example, It can report the number of Stories (currently) Planned in the current iteration... 
( ( Iteration.StartDate <= "Today") AND ( Iteration.EndDate >= "Today" ) AND ( ScheduleState = Accepted ) )

There is an app you can use to see most scope change values: Iteration Scope Change


You can see the summary at the top gives the total number of points added and removed so far.  However, it only counts when stories are added or removed from the iteration.  If you modify the Planned Estimate of a story, that change is not reflected in the number of points or count/list of stories.

Seems like I've see an app for Story Pts planned, accepted, not-accepted etc, but haven't found it so far, on a Friday :-) .... maybe someone else knows of one.