Tableau noob here (hi Ben Bausili). I'm using the following data to create a simple, burn down chart for our Scrum sprints:
|Snapshot Date||Total Work||Work Completed||Work Remaining|
The work is measured in hours and the Snapshot Date represents the state of the data on each day in the sprint (weekends in yellow). Notice, the empty cells. This is my workaround for not being able to get a good trend line to the end of sprint whilst being in the midst of one.
Hurdle 1 - Blend the Total Work and Work Remaining Measures such that they overlay (example attached):
Hurdle 2 - Represent ideal trend line i.e. mean average rate of work from start to finish (first Snapshot Date to last)
Hurdle 3 - Represent current trend line i.e. just like ideal, but based on rate of Work Completed from start to finish
Sad to say, I am stuck on Hurdle 1 (see attached screenshot).
Have any of you the trained eyes to spot the problem in my viz?
Additionally, have any of you the savvy to propose how I might vault Hurdle 2 and Hurdle 3?
Attached the workbook and data, if anyone wants to to see.