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.
Original Message:
Sent: Jun 24, 2022 01:28 PM
From: Alex Deihl
Subject: Data Gathering Help/ Query Counter Help
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)