0

Come Join Polaris at CCC 2014 on April 26th

by Angela 10. March 2014 14:53

So if you haven’t been to Chicago Code Camp yet, you should! I know, I know, there are SO MANY conferences in the Chicago area, how do you choose? It’s true, there are a lot of good ones but here are some benefits to CCC:

a) Because it is community- driven, there is some amazing sessions, including a few sessions on TFS and agile. Here are the ones I am hoping to attend (to be fair I am GIVING two of those talks):

 

Other great sessions cover a wide variety of topics like Windows 8, TypeScript, PowerShell, Unity 3D and Azure, JavaScript and Elixir.

b) it’s FREE for a full day of techie goodness, lunch included. Yeah, you read that correctly, FREE.

c) it’s super easy to get to. It’s right off of 294 and the parking is free.

d) it’s on a Saturday so you don’t even have to miss work! OK, so maybe you don’t see this as an advantage, but I do.

e) Polaris Solutions is a Platinum sponsor and will have a booth. So stop by, say hi, and pick up one of our sweet little booklets on Agile practices.

 

So register now before it sells out, and check out the full list of sessions here: http://www.chicagocodecamp.com/Public/Sessions

0

Chicago ALM User Group Presents: Lab Management in the Cloud

by Angela 12. February 2014 11:22

So, you might have heard, but this cloud thing really isn’t just a fad. And if you’re a TFS user, you might have thought to yourself “Wow, Lab management is pretty rad, but I still don’t have the hardware of personnel required to manage all that infrastructure. It would be awesome if I could extend Lab Management into the cloud!” Sad trombone

We felt that way too here at Polaris.  So we rolled up our sleeves and worked through some of the challenges to make it happen.  Chris Taylor is going to be talking a lot more about it, and doing some demos, at the February edition of the Visual Studio ALM user group this month, at the Aon Center in Chicago.

Join Us Wednesday, February 26, 2014 from 6:30 PM to 9:00 PM

Be sure to sign up soon! http://chicagoalmug.org/ 

Description:

With the introduction of Lab Management in 2010, Team Foundation Server presented the opportunity to do automated build-test-deploy on Microsoft Hyper-V servers.  Although the tool was extremely powerful and cost of entry far less than any physical implementations it didn’t offer the flexibility of working with pre-existing physical labs as well as other virtualization platforms like VMWare or Parallels.  In Team Foundation Server 2012 Microsoft addressed this by introducing the “Standard Lab” environment in parallel with the “SCVMM Lab” environments.  This now allowed for any combination (virtual or physical) of machines to be added to a lab environment and provided nearly all the same functionality as provided in the SCVMM based environments.

At the same time, Microsoft had been working diligently on their Azure platform, all based in Windows Server 2012 and finally opened up the ability to both provision new virtual machines as well as exposed this functionality to other applications via the Windows Azure SDK. 

Polaris Solutions saw the opportunity to use Windows Azure as a virtualization platform to run automated tests and deployments and the tools necessary to accomplish it.  Come learn about some of the tooling that has been constructed to compliment an existing TFS infrastructure and create hybrid-cloud solutions to further lower infrastructure and  testing costs while creating a more quality product.

Speaker Bio:

Chris Taylor is a Senior Consultant at Polaris Solutions based in Chicago.  Prior to joining Polaris Solutions, Chris spent over 5 years in the Payment Card Industry developing applications for commercial and government credit card programs while extending TFS to integrate seamlessly with traditional enterprise software practices while allowing teams to be more agile/iterative within themselves.  Since joining Polaris, Chris has been focused on improving software quality and integration test automation using Microsoft Lab Management, CodedUI, Windows Azure, and Windows 2008/2012 Hyper-V. 

0

The Many Templates of TFS

by Angela 23. January 2014 15:41

If you are a TFS user, especially if you are a TFS administrator, then you know that with every release of Team Foundation Server that there is a rev of the process templates. And if you work on a TFS server that has gone through a number of upgrades, it is possible that your Process Template Manager dialog will start to look like this:

image

So many choices!! Which one to choose? Ahhhhhhhhhhhhhhhhhhh… ::cough, cough:: Back in the early days, there were only 2 out of the box templates. I know, craziness! How did people survive with only Agile and CMMI? Well, there were always the custom templates that you could get off the internet, but that is a can of worms I am not opening in this post.  For now I want to focus solely on the OOB templates.

Over the years, the templates grew up, work item types got added, fields got renamed, workflows got streamlined, and in 2010 a new template was born. But who can remember which one came out with which version of TFS? Usually it’s not a big issue until you are working on a server with lots of legacy team projects, and you need to know what the original base template was. Pro tip, the TFS Team Project Manager can really help you to answer this question AND we found a bug that they recently fixed allowing you to compare 2013 templates all the way back to 2008 templates! Well, I started keeping track, and I get asked questions about this often enough that I figured I would just share my reference.

TFS Version CMMI Agile Scrum
2005 MSF for CMMI Process Improvement 4.0 MSF For Agile Software Development 4.0 N/A -- 3rd party
2008 MSF for CMMI Process Improvement 4.2 MSF For Agile Software Development 4.2 N/A -- 3rd party
2010 MSF for CMMI Process Improvement 5.0 MSF For Agile Software Development 5.0 Visual Studio Scrum 1.0
2012 MSF for CMMI Process Improvement 6.0 MSF For Agile Software Development 6.0 Visual Studio Scrum 2.0
2012.1 MSF for CMMI Process Improvement 6.1 MSF For Agile Software Development 6.1 Visual Studio Scrum 2.2
2012.2 MSF for CMMI Process Improvement 6.2 MSF For Agile Software Development 6.2 Visual Studio Scrum 2.2
2013 RC MSF for CMMI Process Improvement 7.0 MSF For Agile Software Development 7.0 Visual Studio Scrum 3.0
2013 RTM MSF for CMMI Process Improvement 2013 MSF For Agile Software Development 2013 Visual Studio Scrum 2013
2013 Update 2 MSF for CMMI Process Improvement 2013.2 MSF For Agile Software Development 2013.2 Visual Studio Scrum 2013.2

 

Now, I don’t *think* I have missed any versions here.  All of the major TFS releases, and some minor releases, have been covered.  But I’d love some feedback if you notice any minor versions that I may have missed. And I’ll come back and update this when TFS inevitably gets another update, and another rev of the templates :)

Tags:

Agile | Application Lifecycle Management | ALM | Scrum | Process Methodology | SDLC | Team Foundation Server | TFS | TFS 2008 | TFS 2010 | TFS 2012 | TFS 2013 | TFS Administration | TFS Power Tools | CMMI | Process Templates

0

Quick Tip on Debugging TFS30139 Issues

by Angela 12. December 2013 17:27

I’ve had a few people I know run into this recently, and there does not seem to be a lot of guidance out there about process template customization, in terms of troubleshooting or tips and tricks. While running through process template updates to move clients from TFS 2005/2008/2010 to TFS 2013 I would occasionally encounter one of the annoyances of working with XML by hand:

clip_image002

Oh THAT is helpful.  And if you’ve ever seen the contents of a process template you know this could be one of about a million different problems in hundreds of files.

Now if you do a lot of template customizations, well just stop it, right now, please. The more you customize the more you need to maintain, the more you potentially have to upgrade by hand when you move to a new version of TFS.  There are times when heavy customization is necessary, but I often find people customize without understanding what the OOB template does in the first place. Unless you are checking your templates into source control, being very methodical about isolating changes and testing, and commenting your changes just like you do with your application code, you’re going to run into problems during upgrading. But chances are you’ve already gone down the path and here you are…

Enter TFS consultants. I prefer to do most of my process template editing directly against the XML using Notepad when I can. I know, it’s a bit old school, but there are a lot of us out there so I figured why not share? Inevitably, you misspell something, miss a closing bracket, enter an errant blank space where it does not belong, the common XML “bugs” that can be really difficult to track down.  And as you know, Notepad does not have a debugger.  So like me, I’m sure at some point you’ve tried to upload an updated process template using the TFS Process Template manager and seen the dreaded “TFS30139: The process template is not configured properly.” ::SIGH:: Now what? Well, if you followed my previous advice and were methodically checking in distinct changes, you know what you last changed. Kind of like CI for process templates :)

Enter the power tools. The TFS Power Tools contains a great process template editor that you can use in place of a lot of the command line tools for importing and exporting work item type definitions. You’ll need to install it on a machine running Visual Studio Professional or better, FYI.

clip_image002[5]

It gives you some great visualization tools, allowing you to edit fields, configure the forms, visualize and edit workflows, states, and transitions, and an easy way to open and dig through all the nitty gritty details of everything else that a process template entails too.  As an added bonus, it will give you MUCH better error diagnosis information if something is wrong. So for the previous error, I attempted to open the process template. But this time I got a much more friendly message, pointing me at the issue:

clip_image002[7]

Because I knew that the last thing I changed before my last successful upload of the template was the ProcessTemplate.xml file. I knew exactly where to look and lo and behold, I’d left off a closing bracket at the exact location specified by Visual Studio. So I made the quick fix, successfully imported the updated template to the collection, and checked in the updated template file to SCM. Much better!

clip_image002[11]

There are lots of potential tools and editors out there for process template editing, and everyone develops their own style. I often find myself leveraging several different tools in conjunction during a process template upgrade, it can be a lot of trial and error.  They all have advantages and disadvantages, I’ve tripped over a few myself (like this little quirk with the Team project Manager extension if you’re trying to compare 2008 and 2013 templates). I should blog about some of those adventures too :)

Hopefully this gave you some new options you may not have been aware of before.

0

Trying Something new with the ALM User Group in December

by Angela 3. December 2013 13:50

So it’s time again for the annual Christmas Edition of the ALM user group. Normally we do the normal “dinner and a movie” approach, maybe having a special guest speaker or some kind of presentation contest. This month I wanted to do something different.  In December, we’ll be doing an Open Spaces concept. So Open Spaces is sort of an “unconference” thing, where you enter into it with no formal agenda and let the attendees decide what is important and/or interesting to talk about. So think of a topic you’d be willing to lead, or a topic you would like someone else to lead. A few I’d be interested in talking about are transforming organizations to Agile, upgrading legacy systems to TFS 2013, and agile testing.  We will write them on a board, pick some locations for people to gather, and then you vote with your feet, bouncing around if need be.

As an added bonus, if you’ve been attending the ALM user group for a while, you know that December is “Angela cleans out her SWAG closet” month.  So I’ll have lots of fun giveaways including pens, stickers, mouse pads and LOTS of books. I’ll even have special prizes for people who lead an Open Spaces discussion during the meeting (think XBox/Kinect games, Arc mouse, T-Shirts).

So I hope to see you in Downers Grove next week.  I always enjoy our December meetings, and not just because of the cookies :)

Be sure to register soon so I can order the right amount of food!

 

 

Join Us Wednesday, December 11, 2013 from 6:30 PM to 9:00 PM
Location:  Microsoft-Downers Grove 3025 Highland Pkwy, Ste 300, Downers Grove

Speaker Bio: You, me, anyone who is interested in speaking!

Agenda:6:30pm dinner 7:00pm Open Spaces Kickoff

RSVP Now to Attend

0

Building Software, One Room at a Time

by Angela 30. November 2013 21:33

Comparing software development to “building a house” is one of those analogies that sets my teeth on edge. It oversimplifies everything that goes into designing and building a good product, and it also creates some unrealistic expectations in terms of estimation and effort, both for development and testing. I heard it yet again recently, and it just shocked me that it’s still being bandied about these days. C'mon, don’t act so shocked, you probably have said it yourself or heard it said at some point. I know I have, on both accounts. And you know what, it's OK, I’m not here to judge you. Unless you are still saying it, then I will judge you quite harshly :)

There was a time when this was far more true of an analogy than it is today. As someone whose original passion was "architecture", as in, creating blueprints for houses, it made a lot of sense.  Plans are good, and who doesn't like structure and rules? You see, there was a time when software was created by pouring over designs for the right "feel", sometimes for days or weeks to establish a solid foundation. Remember when SOA and OOP were the hot new things?  Before a single line of code was written we had UML diagrams and if we were really fancy stubbed out methods for the developers. And sure, when building a house every angle is inspected, measured and re-measured, the location and size of every supporting wall is verified, every window placement is compared to housing codes, all before a single piece of wood was sawn or hammer was swung. Then contractors are set loose with the specs to build the house according to a well laid out plans. Except what if by the time it was delivered, the homeowners didn’t want to actually live in the house they asked for in painful detail without some major rehab? The colors are all wrong, the yard is too small, the garage is too narrow, there aren’t enough bedrooms. Could you imagine?! In home construction, nobody sane would do that, and yet it happens all the time with software. Well, there you have it, the analogy is already somewhat blown. But there's more.

You know you've been on THAT project. You know the one - late, way over budget, customers are screaming that it isn't what they asked for even though you have signed requirements specs that say it is. Heck, even if you are just NOW getting into software development you're probably going to experience this still at some point. Particularly if you work someplace that is still stuck in a Project Plan driven mentality, a.k.a. "Waterfall" ::cue dramatic music::  Who just let out a little shudder? Now don't misunderstand, I'm not a hater, waterfall-based methodologies can work well in some scenarios, but generally even waterfall enthusiasts are not following a strictly traditional waterfall approach. And to be fair, even "real" waterfall, as I learned it back in college in the late 90's, dictated iterative practices. But often that little nugget gets lost in translation in favor of forever marching forward through a seemingly unending tunnel of quality gates, attempting to hit arbitrarily established milestones. So back to my original point. Building software is not just like building a house, or maybe the more correct way of conveying my thoughts is that building software SHOULD not be like building a house. And if it is at your company, I do not want to work there. Unless you're looking for me to facilitate an intervention of sorts. Let me explain...

Imagine you want to have a custom house built. And let's say you already know more or less what you want. Tudor style, 3 bedrooms, 2.5 bathrooms, eat-in kitchen, with a detached 2 car garage. Maybe you even have an existing blueprint because plenty of houses like that already exist, so why re-invent the wheel right? Work begins, and the house starts becoming real. But even after several weeks of work, while things may start to look like a solid shell of a structure, you cannot live in it.  Well, not legally anyway. There is probably no plumbing yet, certainly no electricity, perhaps the roof is not even yet in place. You also cannot decide you now want something more Spanish style, single storied and sprawling, with an attached garage and a courtyard garden in the center. Well, technically you COULD decide to do that but it would require MASSIVE structural rework, new permits, perhaps a different construction crew, and of course SIGNIFICANTLY more time and funding to complete. OK, so I suppose this is one parallel you can draw to software development, but again this is more of an issue in waterfall shops, particularly if you are already deep into development before someone realizes a much earlier decision was a poor one. Many thousands of man-hours will get wasted, people may lose their jobs, customers will be unhappy, and you likely will end up with a Spanish tiled, Tudor style home with a semi-attached 2 car garage that has a courtyard in the center of it. So with building a house, you will not realize the value of the product and be able to use it until the last finishing nails are hammered into the last room, and major feature change requests will almost always be unfeasible to honor even early on in the construction process without MASSIVE negative consequences. Do you want to build or pay for software that is built that way? I certainly don't. 

I don't see housing contractors ever building homes one fully functional room at a time, allowing the home owners to live in it long before it is finished. I do not see them redesigning the blue prints and only ordering enough supplies for each room about to be built to incorporate changing design trends, evolving safety codes, nor do I see them accommodating the ever-changing whims of the owners.  "Oh. You've decided you want an open floor plan instead of separate kitchen and dining rooms? No problem, we're just finishing the main bathroom and haven't even framed the rest of the first floor yet..." Yeah, no. I also do not see those contractors getting the homeowner's signoff on each finished component before moving on to the next one, incorporating feedback and change requests, continuing this iterative process until the house is complete. Maybe you're thinking, "well, we don't have the ability to do any of those things today when we design, code, test, and deliver software either". I'm sorry to hear that. We should talk, there's a 12 step program to help you, and you've already admitted you have a problem which is the first step to recovery. Well, there ISN'T a program, sadly, but I often joke that there *should* be.

Now this is an easier problem to solve in software. Software teams CAN be flexible, adapting to changing needs of end users. Software can be delivered in small, working, usable pieces to deliver value as soon as a few weeks after the project begins. And it doesn't have to cost more. It can actually cost FAR less if you do it right. This is part of the reason I am such a proponent of Agile and Scrum. But honestly that is another topic and this post is already long enough so we'll defer that conversation for now.

So here is one place where building a house and building software ARE remarkably similar.  Estimates. Regardless of what a contractor tells you, no one knows for sure exactly how long building a house (or software) will take. Sure we can ballpark it, but every job is different. People will sometimes push back and call that a copout consulting answer, but it's the truth, and I try not to make a habit of lying to the people paying me to work for them. And if you demand exact delivery dates, are unwilling to compromise on features (maybe the rotating shoe rack in the closet really isn't NECESSARY), and have immovable end dates, well, you may want to refer back to the 12-step program that I mentioned earlier. No one can account for bad weather, people getting sick, catastrophic hardware failures, or that the latest version of the .NET framework that was just released has added complexities that cause even the most experienced programmers to take 50% longer to get things done for a few weeks. Should you go so far as to expect the team to commit to dates, deliverables, AND cost - to the point they take a hit if any of those things slip - well, prepare yourself for a sandbag big enough to hold back a hurricane, or to have people eventually seek alternate employment. NO ONE wins. And yet these kinds of unrealistic expectations reoccur everywhere I turn in the tech world. Maybe someday more software teams will be able to hold stakeholders and end users accountable for the quality of requirements, and refuse to take on change requests after work has begun without serious concessions, seems logical and fair. Ahhh, dare to dream :)

So now can we stop comparing software to building houses? Please and thank you.

Tags:

Application Lifecycle Management | ALM | Agile | development | Process Methodology | Scrum | SDLC

0

St. Louis Day of .NET is Next Week - Sign Up Before It Sells Out

by Angela 5. November 2013 23:32

I’ve been hearing about St. Louis Day of .NET for some time now but up until recently I just hadn’t thought to attend.  I mean, we have TONS of events in Chicago, so I always made excuses.  This year, Polaris Solutions has stepped up to support STLDODN as a Platinum sponsor.  We're planning on not only participating, but we have a few folks speaking, and we are even hosting a booth so be sure to stop by and say hello! I’ll be the redhead, also, the only woman in the booth so I’m easy to spot :)  If you wanted to catch one of our talks, here is the run-down:

Chris Kadel will be participating in the TFS pre-compiler on Thursday Nov 14th from 8:30am to 5pm: http://www.stldodn.com/2013/pre-compilers.  It is a FULL-DAY hands-on workshop and it’s only $75 to attend, so sign yup fast. You can’t get training like this for such an amazing price anywhere else that I know of.

A Pragmatic Intro to Unit Testing by our very own Josh Gillespie

Advanced OOP by our newest team member and former Softie Clint Edmonson

Agile Testing in a Waterfall World by your truly!

Application Architecture Jumpstart also from Clint

Dude I Just Stepped into Your Code from Josh

 

If you haven't registered yet, click on "Register Now!" at the top of the website and find out why people love this event so much.  http://www.stldodn.com/2013/what-is-the-day-of-.net.

0

Visual Studio 2013 Launch Event Coming to Chicago

by Angela 4. November 2013 15:18

So in case you’ve been living under a rock for the past few weeks, Microsoft released a new version of its Visual Studio ALM Tools including Team Foundation Server, Microsoft Test Manager, and Visual Studio. I know! Feels like 2012 just launched doesn’t it? With their new release cadence, if you blink you could miss a new version, or at least a few updates. It’s pretty amazing actually.

While there is an official BIG launch party happening on November 13th in NYC, you can also logon for the virtual launch that day if you can’t get away to the Big Apple on such short notice.  Although right now you don’t appear to be able to actually register for the virtual launch – DOH!  For now you can at least add it to your calendar, hopefully they will fix that soon.

I also just heard that there are also some smaller in-person launch events around the U.S, possibly hitting a city near you.  Sadly I will miss the Chicago launch event on November 20th, I’ll be at the MVP summit in Bellevue Washington. Not a bad trade-off though ;)  But if you’re in town, check out the Chicago event details and register quick before it fills up! And check back with the events site often because more cities will be opening up soon.

Agenda

image

Location

Drury Lane Convention Center

100 Drury Ln
Oakbrook Terrace Illinois 60181
United States

image

 

Some events are not listed on the events site yet, so here are some other cities coming on-line and a link to get registered:

12/3

Boston, MA

12/3

Nashville, TN

12/3

Bellevue, WA

12/4

Washington, DC

12/4

Philadelphia, PA

12/4

Miami, FL

12/5

Phoenix, AZ

12/10

Atlanta, GA

12/10

Denver, CO

12/11

Concord, CA

12/11

Harrisburg, PA

12/12

Sandy, UT

1/15

Los Angeles, CA

1/21

Mountain View, CA

0

Efficient Testing with Microsoft Test Manager – Slides Posted

by Angela 24. October 2013 10:42

I wanted to be sure to share out the slides that were presented at the testing events that I recently spoke at. If you happened to attend one of the events where Chris Kadel presented, he should be posting his slides shortly. Now in case you’re reading this post and thinking “what on earth are you talking about Angela?”, Microsoft recently began a tour of the central US focusing on efficient testing, and even if you did NOT attend, you may find the following information useful so read on…

These events lasted a half day, and covered manual testing and collaboration with MTM, automated testing with Visual Studio, and managing environments and automating the Build-Test-Deploy scenario with TFS Build and Lab Management.  My slides are posted on SlideShare, and the agenda is below.  There are still some events open including St Louis, Kansas City, and Minneapolis MN so you may not have missed it entirely.  Sign up soon because these events have been selling out!

How do I integrate better with the team?
QA is near the end of the process chain, so one of the best things they can do to be successful is improve their efficiency and collaborate better with the development team. In this session, we want to answer all of these questions: What if you could draft and select test cases early in the project and ensure you have test coverage by assigning them to requirements? What if the bugs you discover could automatically include data about the underlying behavior of the application and the machine it’s running on?
Are you getting enough information about a release to know what to test? Which new features have been implemented? Which haven’t? Which bugs are supposedly resolved? We’ll discuss how to take advantage of the opportunities for improving collaboration between testers and developers.
What should I automate?
While manual testing is always going to have its place, there are several types of tests that can be automated for efficiency. In this session, we’ll discuss everything from automating functional and load tests to the automation of writing test case steps and designing for reuse.
How do I set up a dev/test environment?
Today’s applications are more complex than ever and it can be very challenging to set up and maintain these environments. Many organizations resort to a small number of shared environments, but you are trying to keep up with frequent developer builds, concurrent projects, and ever-changing data.
This session introduces Microsoft’s Lab Management solution which allows developers and QA to self-provision their own environments. We’ll look at you can take advantage of virtualization (on-premises or cloud) to create environments, roll them back to known states, and attach them to bugs while minimizing the labor in your data center.

0

These are a few of my favorite things, about TFS 2013 (Part 1)

by Angela 18. October 2013 13:31

Are you picturing a redhead dancing around a large bedroom singing about string and warm woolen mittens?

Yeah, it’s kinda like that. Only I’m no Julie Andrews, I don’t actually have a very good singing voice, and our house is not nearly that fancy :)  Also, instead of brown paper packages I am singing the praises of the MTM Test Hub, Work Item Charting, and awesome things like that.

As you’ve probably heard TFS 2013 released yesterday. A full day ahead of time, I know!  And like any passionate ALM consultant I’ve been using TFS 2013 for some time now. If you’re taking advantage of TFS Service, you have been too whether you knew it or not. So on to my first favorite thing about TFS 2013. Work item charting. The concept of work item charting is a pretty simple one, and frankly one customers have been clamoring for since TFS 2005. Business users do not want to have to learn SSRS to get quick, custom views that they can use to analyze work items.  And frankly, while Excel ad-hoc reporting is much easier than SSRS, it’s still not an “EASY button” solution for simple work item based charting/reporting. Thanks Staples for giving me that reference. 

So let’s divine in a bit shall we?  We will be working with one of my pet projects, a Scavenger Hunt application for the phone (if someone creates one soon, I’ll know where you got the idea now!) Assume we have some simple queries, for instance one which pulls back ALL tasks in a team project. This could be a lot to take in analyze, especially on large, established projects with multiple teams. So, below we have work items, tasks, bugs, etc.  All assigned to various people, planned for different sprints, and so on and so forth. 

image

But what if I wanted a quick visualization of work item types, or work assigned to various team members across the entire project? Not a super easy way to do that in any of the previously available reporting methods.  Here is where Work Item Charting comes in.  You might notice a new menu item called “Charts” (circled above) in the web tools for TFS 2013.  When you switch your view to Charts it will show you any existing charts for that query, as well as the ability to create new charts.  So in my case, I already had a chart out there which breaks down all work items by type. Marginally useful, but maybe another chart TYPE would actually be a better way to visualize the data.  So the first thing I want to do is try different chart types, and see if something else strikes my fancy:

image

I *love* that as you make choices in the edit box, it automatically gives you a preview of the resulting report. That will save SO many clicks.  So I changed the chart type to a stacked bar, changed the sort and saved the report.

image

A bit more useful, but I’d like another view available, this time including assignment data.  But I’ll need to make some changes to my query, because if I try to simply show this in a new chart with the existing data, you’ll notice I do not even have an option to group by assigned to:

image

Think of the query as your chart data source, meaning all rows returned will be displayed, and even more importantly, only the fields returned by the query will be available as well.  So if my query returns work item type, title, and state then those are the only fields that I can report on. AND only fields with a reportable type of “dimension” can be used for grouping. These little nuggets often trip people up, they assume all of the fields for the returned rows are available and available for grouping/sorting. So I need to go back to my original query, and add the assigned to field to add that data to my chart:

image

Now when I go back into my charts, I have another field that I can use for pivoting my data!

image

 

Well, I could certainly spend FAR more time on this topic, but I just wanted to give you a little taste of one of my favorite features of TFS 2013 – Work Item Charting.  Next up, the new web Test Hub!

Tags:

ALM | Application Lifecycle Management | Collaboration | Process Methodology | Productivity | SDLC | Team Foundation Server | TFS 2013 | TFS Service | Visual Studio 2013 | Work Item Tracking

Powered by BlogEngine.NET 2.7.0.0
Original Design by Laptop Geek, Adapted by onesoft