Displaying effort per day

harropda ⚪️
edited January 4 in Charting

My Task Management data contains 1 row per User Story. Each row will contain start date, end date and estimated effort (which will likely be less than the story duration, e.g. Story starts on Monday, ends on Friday and will take 10 hours to complete). A row would look like:

¦ Program ID ¦ Story ID ¦ Start Date ¦ End Date ¦ Total Effort ¦

Each story is associated with a Program, of which there are many.

I wish to visualise the total effort per day for each Program (where Program will be a filter) on a timeline. I cannot conceive of a way to achieve this without transforming my data from one-row-per-Story to multi-row-per-Story, where each row is one day in the life of the story that contains the average, so it looks like this:

¦ Program ID ¦ Story ID ¦ Date Day 1 ¦ Average Daily Effort ¦

¦ Program ID ¦ Story ID ¦ Date Day 2 ¦ Average Daily Effort ¦

¦ Program ID ¦ Story ID ¦ Date Day 3 ¦ Average Daily Effort ¦

and so on.

Can I achieve my goal creating a new dataset?