Sprint Burndown report doesn't display the new added field

Question

 We're using Scrum 1.0 template and we would like to customize the Sprint Burndown report by adding a new field, Microsoft_VSTS_Scheduling_ImpedimentHours, onto the chart.

I add this field into "dsBurndown" dataset then save. After that I try to drag and drop this field onto the chart as data field with field value as "[Sum(Microsoft_VSTS_Scheduling_ImpedimentHours)]". However, when I run the report, the sum of ImpedimentHours doesn't display.

Can someone please let me know what I did wrong?

Here is the query from "dsBurndown" after I add the new field:

WITH
    SET [Date Range] AS
        Filter(
            [Date].[Date].[Date],
            [Date].[Date].CurrentMember.Member_Value >= CDate(@StartDateParam) AND
            [Date].[Date].CurrentMember.Member_Value <= CDate(@EndDateParam)
        )
    MEMBER [Measures].[DateValue] AS
        [Date].[Date].CurrentMember.Member_Value


SELECT
{
    [Measures].[DateValue],
    [Measures].[Work Item Count],
    [Measures].[Microsoft_VSTS_Scheduling_RemainingWork],
    [Measures].[Microsoft_VSTS_Scheduling_Impediment]
} ON COLUMNS,
{
    CrossJoin(
        [Date Range],
        [Work Item].[System_State].[System_State]
    )
} ON ROWS
FROM
(
    SELECT
        CrossJoin(
            StrToMember("[Team Project].[Project Node GUID].&[{" + @ProjectGuid + "}]"),
            StrToSet(@AreaParam),
            StrToSet(@SprintParam),
            StrToSet("[Work Item].[System_WorkItemType].[Task]")
        ) ON COLUMNS
    FROM [Team System]
}

Thanks

Answer 1

Hello garynguyen,

I am currently looking into this issue and will give you an update as soon as possible.

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us