Reports Guide

Reports Guide

The Reports hub allows you to query, filter, and export effort data across your project or organization.

Accessing Reports

Navigate to Boards > Effort Reports in your Azure DevOps project.

Reports Interface Overview

The Reports hub consists of three main sections:

1. Filter Panel - Set query criteria
2. Results Grid - View matching effort entries
3. Export Options - Download data as CSV

Filtering Data

Available Filters

Filter	Description
Date Range	Start and end dates for the query
Users	Filter by one or more users
Activity Types	Filter by activity categories
Work Items	Filter by specific work item IDs
Area Path	Filter by area path

Using Filters

1. Set your desired filter criteria
2. Click Run Query to execute
3. Results appear in the grid below

Multi-Select Filters

Users, Activity Types, and Area Paths support multiple selections:

1. Click the dropdown
2. Check multiple items
3. Selected items appear as tags

Clearing Filters

• Click the X on individual filter tags
• Or click Clear All to reset all filters

Viewing Results

Results Grid

The results grid displays matching effort entries:

Column	Description
Work Item	ID and title (clickable link)
Date	Date of the effort entry
Hours	Time logged
Activity	Activity type
User	Who logged the entry
Project	Project name
Area Path	Area path of the work item
Notes	Entry notes

Sorting

Click column headers to sort:

• First click: Ascending (A-Z, oldest first)
• Second click: Descending (Z-A, newest first)

Pagination

Large result sets are paginated:

• Shows 50 entries per page
• Use navigation controls at bottom
• Total count displayed

Summary Statistics

Above the results, you'll see summary statistics:

• Total Entries: Number of matching records
• Total Hours: Sum of hours in the result set
• Unique Users: Number of distinct users

Exporting Data

Export to CSV

1. Run your query with desired filters
2. Click Export CSV
3. A CSV file downloads with all matching entries

Export Format

The exported CSV includes all columns:

WorkItemId,Title,Date,Hours,ActivityType,User,ProjectName,AreaPath,Notes
123,Implement login,2025-01-15,4.5,Development,John Doe,MyProject,MyProject\Web,Fixed auth bug

Export All Data

To export all effort data without filters:

1. Clear all filters
2. Click Export CSV
3. All entries for the project will be exported

Note: Large exports may take a few moments to generate.

Common Query Examples

This Week's Effort

1. Set Start Date to Monday of current week
2. Set End Date to today
3. Run query

My Effort This Month

1. Set Start Date to first of month
2. Set End Date to today
3. Select yourself in Users filter
4. Run query

Development Effort by Team

1. Select "Development" in Activity Types
2. Select team members in Users
3. Set date range
4. Run query

Specific Work Item History

1. Enter work item ID in Work Items filter
2. Clear other filters
3. Run query to see all effort logged on that item

Saved Queries

Coming Soon: The ability to save and share frequently used queries.

Next Steps

• Admin Guide - Configure project settings
• Org Admin Guide - Organization-wide data management