Stack Overflow
Stack Overflow

Questions tagged [burndowncharts]

A burn down chart is a graphical representation of work left to do versus time.

A burn down chart is a graphical representation of work left to do versus time. The outstanding work (or backlog) is often on the vertical axis, with time along the horizontal. That is, it is a run chart of outstanding work. It is useful for predicting when all of the work will be completed. It is often used in agile software development methodologies such as Scrum. However, burn down charts can be applied to any project containing measurable progress over time.

84 questions
0
votes
0 answers

Burndown chart dax code for stories closed from total stories (Power BI)

I have a table named "UX data", There is "issue type" field which consist of different issues in which "story" is one of the issue, "status" field which consist of different status in which "Closed" is one of them, there is "Sprint ID" field as…
Sagarika Shetty
  • 1
0
votes
2 answers

SUMMARIZE or SUM values based on Date fields in another table

I am trying to do a burndown graph on PowerBI. My data is a list of tasks. Each task has a numerical value (EFFORT) assigned to it and there is a total amount of effort for any given month (sum of all EFFORT). As tasks as set to DONE, the ongoing…
Matt
  • 51
  • 5
0
votes
1 answer

SQL query to calculate remaining total using previous row

I'm trying to write a query that will calculate remaining total points for each day when some points have been completed. Story points completed in a day So if my total is 100 points, it should show 99, 97.5, 94.5 as I want to use it in a burndown…
KingWolin
  • 13
  • 3
0
votes
0 answers

How to move tasks thus sprint is not always 100% completed

we use azuredevops in our team and try to understand our efficency by using analytics, especially sprint burndown. When we come to the end of our sprint, we move tasks that are not completed in next sprint. Now, burndown chart show always 100%…
L.Bielefeld
  • 1
0
votes
0 answers

Given array of tasks with open and closed dates, how do calculate a count series to plot in highcharts?

My use case stems from a problem similar to Generating counts of open tickets over time, given opened and closed dates I am given a JSON of objects with one or two properties: open date and closed date (if closed). If the task is still open it won't…
gaudi_br
  • 183
  • 2
  • 12
0
votes
2 answers

Burndown chart starts from today and not the iteration start date

I have uploaded workitems to Azure DevOps and specified iteration start date /finish date with burndown on count of workitems. I am plotting burndown by day but the burndown in Azure starts from the day the workitems were uploaded. Is there a way to…
John
  • 1
0
votes
2 answers

Tool for creating burndown charts that does NOT assume "clock time passes" equals "progress should be made"

I am looking for a program that can make burndown charts which does not assume that just because a day passes by, all work time for that day automatically is assumed to have turned into progress for the current sprint. I am thus not particularly…
hlovdal
  • 26,565
  • 10
  • 94
  • 165
0
votes
1 answer

How use Microsoft.VSTS.Scheduling.RemainingWork field to represent minutes?

According to description of Remaining Work field available here https://learn.microsoft.com/en-us/azure/devops/boards/queries/query-numeric?view=azure-devops#fields-used-to-estimate-and-track-work I set my ProcessConfiguration with "h" for…
Francesco Sclano
  • 145
  • 1
  • 12
0
votes
1 answer

Azure DevOps OData Sprint Burndown Chart not showing 0 story point

I am referring to this MS docs when building Power BI report using OData query. I have slightly modified the query to display Sprint Burndown, sprint-by-sprint and it all works fine until I realize when the team has completed all story points, by…
rick
  • 423
  • 6
  • 17
0
votes
0 answers

Get data required for plotting Burndown Chart using odata Rest API in Azure Devops

We are trying to plot a burndown chart in our application by fetching data from Azure Devops. We are using OData API and WorkItemSnapshot to pull the data for each day in the sprint. Here is the OData Query : …
HHS
  • 83
  • 1
  • 7
0
votes
2 answers

How to reference dynamic last row of an excel table

I have a function here that I'm using for a burndown chart in Excel. This is the initial burndown function below. I would like to replace row H56 with the end of my table (in case the date changes, I don't have to keep updating this value), but I…
Sarah
  • 669
  • 2
  • 8
  • 21
0
votes
1 answer

Generate burndown chart for a swimlane

I have added 2 swimlanes to manage 2 projects. However, when I generate the Burndown chart it displays the performance of both projects. How can I display a burndown chart for a particular swimlane ? Note: I am not allowed to add any pluging
Illep
  • 16,375
  • 46
  • 171
  • 302
0
votes
1 answer

PowerBI - Declining Trend Over Time

I'm working on a PowerBI Dashboard where I have a set number of values (Training Session -3084 Sessions) an assigned date of 2/15/20 and a due date of 3/28/20. I'm trying to show a trend over time of the declining incompletions as we approach our…
MM18
  • 7
  • 3
0
votes
1 answer

TFS 2018 Burndown chart

What is the "Ideal Trend" line in TFS Sprint burndown chart based out of? Original Estimate or Remaining Work? If I add more tasks mid sprint, my remaining work line will show a bump. Will the starting point of "Ideal trend" line also move up in…
alphastar
  • 1
  • 1
0
votes
0 answers

burndown chart in angular 6

I want to implement burndown chart in my angular 6 application.I've tried to implement the burndown chart using D3-burn-down-chart but was unable to as all the samples are available in .js files and I was unable to convet them into .ts files. Here…
Harika
  • 121
  • 1
  • 11
1 2 3
4
5 6