Reporting Page Settings Time in State for Azure DevOps

1. Reports generation.

Choose a report type you want to generate (see the list of reports below).

Open

When generating the reports, you can filter data by Query.

Open

Filter Work Items

Use the Filter Work Items functionality to choose what Work Items will be displayed : Created, Changed or Closed.

Choose how many rows will be displayed on the grid in the drop-down list.

Work Items and Time Range Periods

More information >> https://saasjet.atlassian.net/wiki/spaces/SAASJET/pages/2699788308

Time format

The Format option lets you select the time format how the status duration will be displayed: 

• DHM (Days, Hours, Minutes), 

• HM (Hours, Minutes), 

• h:m (hours: minutes), 

• M (Minutes), 

• Decimal Hours, 

• Decimal Days, 

• Decimal Weeks, 

• Business DHM, 

• Business Decimal Days, 

• Business Decimal Weeks.

Choose Calendar

You can choose a custom calendar you've added previously or a default 24/7 to generate data.

2. Chart Reports.

All reports are available as Grid and Charts.

Three types of graphs are available: Pie, Bar and Area Charts.

For more information, visit Chart Reports View.

3. Filtering Work Items.

Use the Filter Work Items by Query functionality to customize report timeframes.

From the drop-down list, you can select three date ranges that allow sorting Work Items depending on the dates of creating, updating, or solving issues.

• Created

• Changed

• Closed

Then you can choose the period for which you want to get the report.

Read more in Issues and Time Range Periods section.

4. Choose a Time format.

The Format option lets you select the time format of status duration:

• DHM (Days, Hours, Minutes)

• HM (Hours, Minutes)

• h:m (hours:minutes)

• M (Minutes)

• Decimal Hours

• Decimal Days

• Decimal Weeks

• Business DHM,

• Business Decimal Days,

• Business Decimal Weeks.

5. Sorting Data.

Click the column to sort the values in descending or ascending order. You can sort any column.