Compare Orginial estimation vs Completed Work at the end of iteration with Odata

[Anonymous]

Hi,

I'd like to take a snapshot at the end of an iteration (Agile sprint) with Odata query to compare OriginalEstimate vs CompletedWork in Azure DevOps through Odata query.

I use the WorkItemSnapshot feature, but I can't isolate the data of the last day of the sprint.

Can you help me?

Regards,

[v-lid-msft]

Hi @Anonymous ,

Where do you want to store the snapshot? We can create another table using the same query  and filter the data you want at the end. Then we can compare the data with the origin table.

If it doesn't meet your requirement, could you please describe the expected result with more detail?

Best regards,