Folks,
First of all, this question is based on the premise that I´m connecting Azure devops data through the Analytics View and all fields available were selected to the view.
I want to track whether the development team stuck to the plan or worked on backlog items that have been created OR have been added into the sprint after the sprint was started. But I have no clue on how to do it. Apparently is looks easier to write an IF statement for the ‘Creation Date’ criteria.
But how to effectively identify when an item has been added after the sprint start?
Unfortunately,there is not a built-in report can be generated to get what you want. Since TFS/Azure DevOps is an effort tracking system and not a time tracking system it is a loosing battle to try and track billable time as part of TFS/Azure DevOps.
Agile projects don't focus on how long individual tasks take(Same concept as when items first added to a sprint) -- they focus on how much value the development team is providing over the course of a set period of time. One thing might be estimated low, one task might be estimated high, but it ultimately doesn't matter as long as the team delivers what they committed to deliver.
About Scrum, suggest you take a look at this related question: Reporting on completed sprint
If you insist on achieving this, you could use some 3-rd party extension such as Imaginet Time Sheet & Timetracker. For example, about time tracker, it is fully integrated into TFS, which allows tracking directly against workitems and offers data export as well as automatic filling of the fields mentioned above. With the help of the extension, project manager could have all times based on rules automatically reported back into MS Project.