I’m trying to create a project status report (for a "waterfall view" on an agile software project) in Azure DevOps that is based on a list of Epics and the corresponding Features beneath them. The report should contain information about the overall effort, the current progress (completed features) in % and a planned vs. actual progress comparison to see delays. Best would be to also have the information in a gant chart which is displaying all the information mentioned above. I already tried various extensions for Azure DevOps but I always failed to implement the planned vs. actual progress
Can someone please guide me on how to achieve this, especially with the target vs. actual comparison?
I am afraid that there is no out-of-box method can fully meet your requireemnts. (Generate the report to show the actual progress(overall effort, progress and so on) and the target progress)
In Azure DevOps Service built-in feature, the Rollup feature in DevOps. Rollup provides summed values of select fields for all child work items of a parent. But the system doesn't support rollup of the Effort,Completed Progress across product backlogs and portfolio backlogs.
It also supports using Query Chart obtain rollup of additional data fields in Azure DevOps work tracking data.
These features have limitations and can not fully meet your needs. As far as I know, the existing extension mainly displays the current progress, and it cannot achieve the comparison function.
You can consider using PowerBI or Excel to collect the data of the work item query. Then you can perform customized processing on the data and generate reports. For example: Rollup child work item values to parent sample report
I can fully understand your requirement.You can submit a suggest ticket in the site: Developer Community to report this feature.