Chart the progress of several projects

My customer is looking for a chart to demonstrate weekly progress across several projects. All she wants to see is the project name, percentage and the weekly date. I am struggling with a clean way to provide the top level information from a project. I tried "copy a row" with a workflow but it copies all the subtask as well. She is looking for a chart like the attached image. She made the chart in Excel to demonstrate what she wants.

image.png


Answers