Forum Discussion

KBVelasco's avatar
KBVelasco
Frequent Visitor
6 years ago

Help with Burndown Chart

Hello,

 

I've been having trouble creating a "simple" burndown chart from my organization's project data.  A few of my needs are listed below:

 

  • The chart has a y-axis of hours and x-axis of date
  • The first data point for the burndown line should equal "total estimated hours" on the "estimated start date"
  • The last data point for the burndown line should equal zero hours on the "estimated end date"
  • The progress line should show show a running decrease in hours left based time entry totals for each day.

 

I am primarily focused on three tables that are stored offsite in a SQL database.  These tables are Projects, Tasks, and Time Entries.  The relationships between these tables are built around a "Project ID" and a "Task ID." There is no direct connection between Time Entries and Projects other than each tables relationship witht the Tasks table.  Screenshots of the three tables are below.  These screenshots only show the data for one of our projects.  Our database, however, houses hundreds of projects and thousands of tasks.

 

 

I would also like to implement the functionality of the chart to be dynamic in the sense that it can adjust the x/y axis based on the input of two separate slicers (Project Name and Task Name).

 

I've tried to utilize tips from several posts and videos, but none seem to work for my specific case.  Currently I am trying to figure out a way to get the values I need to calculate inside of a separate table built on the CALENDAR function.  This isn't working out for me either, and I feel like I just keep working in circles.  I understand that I may not have provided all of the details needed to get a straight answer to my problem, but at this point, any info would help.  

 

Thank you,

 

Kevin V.

 

2 Replies