azure-devopsagilescrumsprintburndowncharts

How to create query in azure to find change in remaining work field

I want to create a query wherein we can track in a specific sprint, within 24 hour span, how many hours are burned by the team members.

My way of developing this query is if I can find change in the remaining work field , I can track it.

I have created query using @StartOfDay variable. But it is giving me data of tasks which are older than 24 hours also.

Is there any way in which I can limit it to last one day or 24 hours?

enter image description here

Solution

  • Your clauses in the query is not accurate actually. The Changed Date monitors on any changes on the work item but not only Remaining work field.

    In addition, the two Remaining work clauses with >=[Field] or <=[Field] evaluates all, which is not needed.

    To find change in the Remaining work field, you can add a custom field ChangedTime for task:

    enter image description here

    add a work item rule(for inherited process), record the time when Remaining Work field is changed.

    enter image description here

    In the work item query, filter the ChangedTime which is > @StartOfDay('-1d'):

    enter image description here

    And add ChangedTime and Remaining Work in column option so it will display in the query result. You can sort the ChangedTime by time, to get the work items in 24 hours.

    enter image description here

    Or you can export the result in CSV format, and check tasks in excel instead. It supports accurate time filter:

    enter image description here