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 (clickable link to work item)
Date	Date of the effort entry
Hours	Time logged
Activity	Activity type
User	Who logged the entry
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

---

Pivot View

The Pivot View displays effort data in a timesheet-style format, making it easy to see time distribution across your team.

Switching Views

Toggle between views using the buttons above the results:

• List View - Traditional table with one row per effort entry
• Pivot View - Timesheet grid grouped by User → Area → Activity Type

Weekly vs Monthly

In Pivot View, choose your time period:

View	Columns	Best For
Weekly	Days (Mon–Sun)	Detailed daily tracking
Monthly	Weeks (Week 1, Week 2, etc.)	Monthly summaries

Navigating Periods

• Click « Previous to go back one week/month
• Click Next » to go forward one week/month
• Click the current period link (e.g., "Go to this week") to jump to today

Understanding the Pivot Grid

The pivot grid organizes data hierarchically:

Column	Description
User	Person who logged effort (merged cells for multiple rows)
Area	Work item area path (merged cells)
Type	Activity type
Day/Week columns	Hours logged for each period
Total	Row total for that user/area/activity combination

Daily/Weekly Totals

The footer row shows totals for each column:

• Weekly view: Daily totals (total hours logged each day)
• Monthly view: Weekly totals (total hours logged each week)
• Grand Total: Sum of all hours in the period

Filters in Pivot View

All filters (Users, Activity Types, Areas, Projects) apply to the Pivot View. Use filters to focus on specific team members or activity types.

Example Use Cases

Team weekly standup:

1. Switch to Pivot View
2. Select Weekly
3. Review daily totals to see team workload distribution

Monthly capacity review:

1. Switch to Pivot View
2. Select Monthly
3. Filter by specific users