Welcome to Team System Rocks Sign in | Join | Help
in
Home Blogs Forums Photos Tutorials Files Roller
Notion Solutions Main Site

Create TFS Report using Excel: How can I see Work Items that were in state Proposed in specific week (day)?

Last post 07-16-2008, 1:41 PM by shai_rai. 1 replies.
Sort Posts: Previous
  •  04-04-2008, 9:18 AM

    Create TFS Report using Excel: How can I see Work Items that were in state Proposed in specific week (day)?

    As I understood that if I choose Resolved Date (for example), Area path and Current Work Item Count from Pivot table I could see count of Work Items that were in resolved state per week (per mounth or per day), also if I take State field I can see the state of this work items that its have now (all this fields I choose from Pivot Table). Same reports I can do for other states (WI in open state when I take Open Date, in active state when I take Active Date...)

    I hope that what I writed it is  OK, in another case please tell me.

    But if I want to see Work Items that were in Proposed state, what I have to do?

    If  I shoose Created Date (when I create new Work Item it gets this date and the state proposed) I will see the count of Work Items that were created in the date (week) and got the state proposed, but if for example work item was in state open and then got state proposed I couldn't see in what date it was (there is no Proposed Date).

    What I need to do in order to see what work items were in proposed state in spesific week (day) in last too month for example?

  •  07-16-2008, 1:41 PM

    Re: Create TFS Report using Excel: How can I see Work Items that were in state Proposed in specific week (day)?

    Hello,

    You can use WorkitemHistory and select parent state of Proposed.


    Developer & Senior Consultant
    http://blogs.microsoft.co.il/blogs/shair
View as RSS news feed in XML
Powered by Community Server, by Telligent Systems