Create a Trend chart in Visual Studio Online

As you might have noticed from some of my previous posts on this blog, I really like reports. I wrote about how to customize them (here, here and here), how you should use them in your ALM implementation and how to use PowerPivot to your advantage.

When you read these posts, you probably will not be very surprised that I am very excited about the reporting stuff that is currently happening on VSO.

It was already possibly to make simple charts from Flat Lists Queries. This charting functionality allows you to visualize a query as a chart and pin it to your homepage. This process is very well described on MSDN.

Charts page for flat list query showing four charts 

But now…Since the update as of July 21st, it is possible to have some more advanced charts. Meaning charts that use another measure as Count of Work Items, and charts that display a trend.

You can think of examples as:

  • Bug count over the last 4 weeks
  • Number of hours remaining in the current sprint (burndown !)
  • Cumulative flow (number of storypoints over time in a specific state)
  • etc.

Walkthrough

Let me quickly guide you through a simple scenario to create a cumulative flow diagram for Product Backlog Items.

Create some items

First create some PBI’s and assign a value in the Effort field

image

Create a work item query

Create a query (Flat List) that lists all Product Backlog Items and make sure you add [Effort] in the output columns.

Save the query in the [Shared Queries] Folder and call it [Cumulative Flow PBI]

image

Create a chart

Create a chart by clicking the [Charts] sub Tab. Create a Stacked Area, group by State and select Sum of Effort as Values field.

image

Pin to homepage

Once you created your chart, you can pin the chart to your homepage by clicking the […] and choose Pin to homepage.

image

That’s it. This is very cool stuff and sure there is more to come !

Happy charting!

Advertisements

10 Responses to “Create a Trend chart in Visual Studio Online”

  1. Hi,

    I’m having a problem, and is that I can only see “Count” as an aggregation measure. I need “Sum” for a burndown chart.

    What to change to enable having “Sum”?

  2. Forget it guys, the problem only appeared when using Internet Explorer 11, when using firefox, the dropdown list displays Count and Sum as available options for the aggregation functions.

  3. See, this is what I mean (the one without frame is Internet Explorer 11):

  4. Hi renevo,

    Do you know how to create a burndown with a longer time span? The options offered only allow for 1, 2 or 4 weeks.

  5. Meshaal Alshawaf Reply March 19, 2015 at 5:23 am

    Hi Renevo,
    we are using TFS CMMI and the Sum option not appear to us at all.
    why 😦

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: