How to create an EVM chart on Azure Devops?

Question

Kaneko Keiko 0

I am trying to implement waterfall development project management using Azure Devops.

As part of this, I need to create an EVM, but I would like to know how to create an EVM using a dashboard or similar.

How to get the data of EVM to visualize on the dashboard?

1 answer

Answer 1

Azure DevOps does not have a built-in Earned Value Management (EVM) feature, but you can create EVM visualizations using Queries, Charts, Dashboards.

To create an EVM,

Set Up Work Item Tracking, Refer this doc to customize your project. Ensure your project tracks effort estimates (Story Points, Remaining Work), completion states (Done, Closed), and actual effort (Completed Work or custom fields). If fields like Actual Cost are missing, customize your process to add them.
Create Queries to Collect Data

Create saved queries to collect the necessary data: Planned Value Query, Earned Value Query, Actual Cost Query.

To create a query, go to Boards > Queries, click New Query, define filters based on State, Date, or Effort, and then save the query.

enter image description here

Create Charts from Queries, check this doc to know how to add charts to a Query. Open the query, click Charts, then New Chart, choose a Line chart, and configure the X-Axis (Date), Y-Axis (Sum of Effort or Cost), and Group By(State or custom fields).

enter image description here

Go to Dashboards -> Click Edit-> Add Widget -> Add a Query Chart Widget -> Select your saved query and chart.

Arrange your charts to visualize:

By following above steps, you can create an EVM.