How to configure TFS burndown chart to be for effort points not task hours?

Mohamed Heiba picture Mohamed Heiba · Aug 15, 2013 · Viewed 7.5k times · Source

My question is really simple, hopefully the answer will be too.

You all know the task burndown in TFS online right ? Here's an example

enter image description here

Obviously, the y-axis is the remaining hours of tasks. I want to change that to be the remaining effort points of Product Backlog Items and Bugs.

Can I do that ? If so, How ?

Answer

Andrew Clear picture Andrew Clear · Aug 15, 2013

Yes. You have to edit the "Sprint Burndown.rdl" file in your process template (it's in the reports folder). Particularly, you have to change this field:

<Field Name="Remaining_Work">
      <DataField>&lt;?xml version="1.0" encoding="utf-8"?&gt;&lt;Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Microsoft_VSTS_Scheduling_RemainingWork]" /&gt;</DataField>
      <rd:TypeName>System.Int32</rd:TypeName>
</Field>

To reference the effort point field. This isn't the only change that you'll need to make to that file to get this to work (the MEASURE in the SELECT statement also needs to be altered), but that should at least get you started.