I'm looking for a custom chart to compare the "Original Estimate" field with the "Time Spent" field

Question

As a scrum master I want to be able to coach my team on their estimates so that they can learn from their previous estimates and become a more efficient team.

Acceptance Criteria:

A custom chart widget that compares the "Original Estimate" field with the "Time Spent" field sprint over sprint.

NOTES:

I am able to easily accomplish this using two separate custom charts, but I'm looking for a way to combine the two together so anyone can easily compare our "Original Estimates" to the actual time spent on each story.

We use both hours and story points. We point the story using story points based on risks, complexities, and effort. And we break down each story into one to many sub-tasks. Each subtask has an original estimate in hours. I don't know if that matters in this instance, but I figured I would share for additional detail.

Eric Scheberl · Answer

I am trying to accomplish the same thing and wonder if you have any tips and I am not sure how to move forward.

Ryley Fischer · Answer

@Riley Venable - Thank you for your prompt responses, however I apologize, I'm having a hard time following your instructions.

Here is the configuration for my 2D bar chart.

Here is the configuration options for a 2d stacked bar chart.

I do not see the "second and third columns" that you are referring to here.

In the sample table format, you can add the "Original Estimates" and "Time Spent" as the second and third columns respectively.

Riley Venable · Answer

To combine the "Original Estimates" and "Time Spent" charts into a stacked bar chart, you can customize the settings for the bar chart. In the sample table format, you can add the "Original Estimates" and "Time Spent" as the second and third columns respectively. Then, select the stacked bar chart option to display the data as a stacked bar chart. You can use the "Sort rows" or "Zero fill" step as needed to format your data.