I have reviewed posts related to how to visualize the burdown concept in Tableau, but any of the posts seems not to address the specific issues/ data I do have available.
Show how the work is being consumed within predicted budget. Answer the question whether there is a risk for the realization of the project.
Technically, is the orange line (how the project is progressing) above blue one (how it should progress).
Create a plot (orange line) which would show how many kilometers were worked out during the duration of the project. Done.
Add a line (blue one) which would represent “ideal burndown“ (link to concept), but base not on data those reflect the current state of the project (as shown on the below pic) * and end up at the last day (30th of March), but instead make use of some calculated field [end_day_of_project] – to reflected it on X-axis as the farthest to the right point (predicted last day of the project).
The task seems to be trivial – plot a line for which:
Frankly, I stuck how to do it in Tableau.
The blue line is calculated based on the formula taken from https://community.tableau.com/thread/151837, but show the ‘ideal burdown’ just for the already worked out scope of the project.
Thank you in advance for any help - '2 weeks Tableau user'.