Specifically, where do Actual Burndown values in the Burn Down Chart pull from?

[kellykaufmann]

Do the Actual Burndown values in the   Burn Down Chart pull from the values in 'A' (Actual) on the story card in the Task Progress Board? Does it pull from 'Actual Hours' on the Scrum Task form? (Are these the same #)?

Is the chart updated right away with values entered in the 'A' or is there a lapse (e.g. updated daily)?

We did refer to this Wiki page Scrum Charts - ServiceNow Wiki.

[kellykaufmann]

Here's a reply from SN on our HI ticket with the same question:

"The burndown chart graphs the actual burndown line by pulling the information from the metric_instance table.

The code for generating the metric_instance records is defined in two metric definitions:

RM Release Total Story Count (metric_definition.do?sys_id=d3d4752237602000a08a40ed9dbe5ddc)

RM Story State Capture (metric_definition.do?sys_id=c42a0b0137311000913e40ed9dbe5d4d)

Hours are not involved in any of the calculation as the chart only queries data from points.

To better describe this, let's take a look at a sample record in your dev instance.

-We'll take a look at this scrum release record: RLSE0010001

-Notice that it has 548 points and this is the end points that the burndown chart graps.

-If you take a look at the burndown chart for this record, you will see the actual burndown line has three blocks (you'll see the text #1, #2, #3 indicating each block). Each block corresponds to a Sprint of the Release record.

-If you hover over the starting point of the first block, you'll see that it says 'Dec. 16, 2014 204 Points'. Hover over the starting point of the second block and you'll see 'Jan 7, 2015 404 Points'. And so on...

-Where does this data come from? As mentioned previously, they are from the metric_instance table

https://bunzldev.service-now.com/metric_instance_list.do?sysparm_query=definition%3Dd3d4752237602000...

-If you take a look at when these metrics are created, they synced up with what you see on the actual burndown line of the burndown chart. Points are generated from the sum total of stories points for each sprint.

Additional info:

The code for rendering the Burn Down Chart is in a Script Include, BurnDownUtil:

sys_script_include.do?sys_id=c7409b7237131000913e40ed9dbe5d6f

The BurnDownUtil code renders the chart using the following information:

1) The planned start date and planned end dates of the release correspond to the time period for the chart.

2) The chart looks for RM Release Total Story Count metric instance records for the release

...2a) There needs to be at least one of these records, or the system reports there is not enough data to draw the chart

...2b) There can be more than one of these records because this becomes a record of the total story points (as stamped in the start time of the metric instance record)

3) The RM Story State Capture metrics are records of when a story is completed; the story points are deducted from the total remaining points, and a line is drawn from the last previous total to the new total."

[kellykaufmann]

Here's our findings after a conversation with Molly from the PPM team @ SN:

The Sprint Burndown Chart pulls from the 'Story Points' field on the Sprint form. The chart pulls when the Sprint is NOT in 'Draft' or 'Planning' state. A new plotting point is plotted on the Burndown Chart whenever stories (and therefore Story Points) are added or removed.

This 'Story Points' field pulls from the 'Points' field on the Story forms for all stories within that sprint.

I don't think we currently have Stories pulling from points at the Scrum Task level. But I believe we're tracking remaining points/hours at the Scrum Task Level.   If that is the case, we will create a Business Rule to pull 'Remaining Hours' value on the Scrum Task form into the 'Points' field on the Story form. So a Story will pull the 'Remaining Hours' of all the Scrum Tasks related to it.

[Kusuma2]

Hello Kelly

I have the same requirement should you please help me to resolve...

I need to create the Burn down chart for the Sprint.

On the Sprint I have custom fields Total Points,total Burndown and Remaining Points.

On the STORIES table I created the custom fields Points, Burdown Points.

I impleted the business Rule whenever the story burndown points are reduced the Total burndown and the the Remaining fields on Sprint gets Updated.

I want to Utilize the fields which I have created on Sprint table,   to display actual and ideal burn, and total story points for the sprint the same style as the out of box chart.

1.Where do I need to exactly change the code?

2.And also exclude Weekends on the X-axis.

Can anyone share your ideas?

https://community.servicenow.com/community?id=community_question&sys_id=b07ef373db599780852c7a9e0f9619d5

[Jagadeesh R1]

Hello Ajay,

   I have worked on similar requirement to configure the burn down chart based on hours rather than story points. Actually there are two functionalities in ServiceNow still available to derive the burn down chart. If you can search for UI Action in Sprint or Release form there will be two "Burndown Chart" actions in which one is not active. I have tried to follow up the active one but was not successful to track how the values and chart are pulled. But i have traced the inactive UI action and I have traced the flow. If you can follow up the inactive UI action , the values are stored using a Metric Defintion "RM Story State Capture",you can observe the changes in Metric Instance if the story is completed. Later the values are used in Custom chart "BurnDown". I have tried to recreate the burndown chart in hours spent, but not able to achieve because of some scoped application access.Hope this information might help you.

Thanks and Regards,

Jagadeesh R