Skip to main content

Standard report: Projects Overview

Learn how to use the GUIDEreports Projects Overview report to monitor project volume, status, timing, health, and forecasted delivery risk across your onboarding portfolio.

Written by Elan Maynez

Overview

The Projects Overview report gives you a portfolio-level view of how your onboarding and Professional Services projects are progressing.

For delivery leaders, onboarding managers, and project managers, it helps answer one core question:

Are our projects on track, and where do we need to step in?

Use the report to understand current project volume, identify projects that are already late, spot future schedule risk, review project-health indicators, and move from a portfolio signal to the individual projects behind it.

What you can learn from this report

Use Projects Overview to understand:

  • How many projects are currently active

  • How projects are distributed by status

  • Which projects are already late

  • Which projects are forecasted to finish late

  • Which projects are forecasted ahead of schedule

  • What is due in the near term

  • How project health is distributed across the portfolio

  • How long completed projects typically take

  • Which individual projects are contributing to a metric or risk signal

This report is most useful when your question is about projects as a portfolio rather than the individual tasks inside them.

If you need to investigate the task work contributing to project risk, move from Projects Overview into Task Management.

Filter the report

Projects Overview uses the standard GUIDEreports filters.

These include filters for:

  • Customer

  • Project and task custom fields

  • Project status

  • Task status

  • Project tags

  • Task tags

  • Task responsibility

  • Task start and due dates

  • Project start and end dates

You can combine filters to narrow the report to the portfolio you actually want to evaluate.

For example, a delivery leader could filter to:

  • Project Status: Late

  • Project Custom Field: Enterprise

  • Project End Date: This Quarter

Now the report answers a more focused question:

Which Enterprise implementations ending this quarter are currently late?

For a complete explanation of shared filter behavior, see Use GUIDEreports: Filters, drilldowns, sorting, and navigation.


Understand project status

Projects Overview uses the following project status categories:

  • Pending

  • In Progress

  • Done

  • Late

  • Cancelled

  • On Hold

Note: Not Applicable is a task status. It is not a project status.

Status-based widgets can use different built-in rules, so do not assume every widget includes the same project population.

One especially important example is On Hold.

On Hold projects are included in Total Active Projects and other applicable project-focused active metrics.

That differs from some task-focused reporting, where tasks from On Hold projects may be excluded from active-task calculations.


Understand the size of your portfolio

Start with the project-volume metrics to understand how much work your organization is managing.

Metric

What it tells you

Projects Created

How many projects exist in the current reporting population.

Total Active Projects

How many projects are active after excluding Done, Pending, and Cancelled. On Hold is included.

Completed Projects

How many projects are currently in the Done category.

Projects Started This Year

How many projects have a start date within the current calendar year.

Total Active Projects

Question it answers: How many projects are we currently managing?

Total Active Projects excludes:

  • Done

  • Pending

  • Cancelled

It includes On Hold projects.

Use this metric as a high-level measure of current portfolio size.

It is especially helpful as context for other risk metrics.

For example:

8 forecasted-late projects out of 80 active projects

means something different from:

8 forecasted-late projects out of 12 active projects.


Understand current project status

Portfolio-status widgets help you understand where projects currently sit in the delivery lifecycle.

Widget

What it shows

Projects by Status

All projects grouped by project status.

Active Projects by Status

Projects grouped by status after excluding Cancelled, Pending, and Done.

Late Projects

Projects whose current status category is Late.

Projects by Status

Use Projects by Status when you want a broad view of the entire project portfolio.

Because the widget does not apply an additional built-in status exclusion, it can include projects across active and non-active categories.

Active Projects by Status

Use Active Projects by Status when the question is specifically about work that remains part of the active delivery portfolio.

Projects that are:

  • Cancelled

  • Pending

  • Done

are excluded.

Late Projects

Question it answers: Which part of our portfolio is already behind schedule?

Late Projects counts projects whose current status category is Late.

This is a current-state signal.

Use it when you want to find delivery problems that have already occurred.


Monitor project health

Active Projects by RAG Status

Question it answers: How is project health distributed across our active portfolio?

This chart groups active projects by their available RAG status.

Projects that are:

  • Done

  • Pending

  • Cancelled

are excluded.

Use the chart to see whether concerning project-health indicators are isolated or becoming more common across the portfolio.

A growing concentration of projects in a concerning RAG state can be a useful reason to investigate further.

The RAG indicator tells you where to look. It does not by itself explain why a project is healthy or at risk.


Identify current and future schedule risk

Projects Overview helps separate two important questions:

Which projects are already late?

and:

Which projects are likely to finish late?

These are not the same thing.

Metric

What it tells you

Late Projects

Projects currently represented by the Late status.

Projects Forecasted Late

Ongoing projects currently expected to finish later than planned.

Projects Ahead of Schedule

Ongoing projects expected to finish ahead of schedule.

Projects Forecasted Late

Question it answers: Which ongoing projects are showing future schedule risk?

This metric counts projects identified as forecasted late while excluding:

  • Done

  • Cancelled

  • Pending

Use it as an early warning signal.

A project does not have to be currently Late to be forecasted late.

That distinction gives your team an opportunity to investigate schedule risk before the target date is missed.

Projects Ahead of Schedule

Question it answers: Which projects are expected to finish earlier than planned?

This metric counts projects identified as forecasted ahead of schedule while excluding:

  • Done

  • Cancelled

  • Pending

Use it to identify projects progressing faster than their current plan.

It can also be useful when reviewing whether project timing assumptions reflect actual delivery behavior.


Compare planned and forecasted delivery

The project drilldown includes several timing fields that can help you investigate forecasting.

Field

What it helps you understand

Due Date

Planned project completion.

Forecasted End Date

Currently expected completion.

Planned Duration Days

Planned project duration.

Forecasted Duration Days

Currently forecasted project duration.

Forecasted Variance Days

The reported difference between planned and forecasted timing.

Is Forecasted Late

Whether the project is currently forecasted late.

Is Forecasted Ahead

Whether the project is forecasted ahead of schedule.

Use these fields together rather than interpreting one value in isolation.

For example, a forecasted-late project becomes much easier to investigate when you can see both its planned Due Date and current Forecasted End Date.


Review near-term delivery

Projects Due This Month

Question it answers: Which projects are expected to reach their planned due date this month?

This widget includes projects whose due date falls within the current month while excluding completed or cancelled projects.

Use it to understand near-term delivery commitments.

This can be particularly helpful at the beginning of the month when teams are planning:

  • Go-lives

  • Customer handoffs

  • Resource needs

  • Leadership reviews

  • Launch preparation


Understand project duration

Avg Project Duration

Question it answers: How long do completed projects typically take?

Avg Project Duration uses projects in the Done category.

Project duration uses the working days configured at the workspace level.

Use this metric as a historical delivery benchmark rather than a measure of currently active projects.

For example, a Professional Services leader might use average duration to understand whether implementation timelines generally align with planning expectations.

Note: Because duration uses workspace working-day configuration, interpret the metric using your organization's configured working schedule rather than assuming calendar days.


Use Cash Value as project context

Project drilldowns can include Cash Value.

Cash Value is the value stored on the project and may be populated:

  • Manually by a user

  • Through automation, depending on your workspace configuration

Use Cash Value as additional project context when your organization uses it in portfolio reviews.

For example, a delivery leader might use it to understand whether forecasted-late projects represent a particularly important portion of the portfolio.

Important: Cash Value represents the value stored on the project. Its business meaning depends on how your organization uses that field, so it should not automatically be interpreted as recognized revenue.


Drill into individual projects

Summary metrics answer:

How much?

Charts help answer:

Where?

The project drilldown helps answer:

Which projects?

Projects Overview drilldowns can include fields such as:

  • Project and customer

  • Internal and external summaries

  • Start and due dates

  • Done date

  • Forecasted end date

  • Cash Value

  • Billing Rate

  • Forecast indicators

  • Planned and forecasted duration

  • Forecasted variance

  • Phase and milestone names

  • Project status

  • RAG information

Every drilldown column header is sortable A → Z or Z → A.

For definitions of the individual fields, see the GUIDEreports drilldown field reference.


Example: Prepare for a weekly portfolio review

The following is an illustrative Professional Services scenario.

A delivery leader is preparing for a weekly onboarding portfolio review.

Their question is:

Which projects need intervention, and which risks can we address before they become late?

1. Start with portfolio size

They check Total Active Projects to understand how much project work the team is currently managing.

2. Review current health

They use Active Projects by Status and Active Projects by RAG Status to see how the active portfolio is distributed.

3. Separate current problems from future risk

They compare:

  • Late Projects

  • Projects Forecasted Late

Late Projects identifies problems that already exist.

Projects Forecasted Late identifies work that may become a problem if nothing changes.

4. Review upcoming commitments

They check Projects Due This Month to understand which delivery deadlines are approaching.

5. Drill into the affected projects

For the projects that need attention, they review fields such as:

  • Customer Name

  • Due Date

  • Forecasted End Date

  • Forecasted Variance Days

  • Status Label

  • RAG information

  • Cash Value

Now the meeting can move from:

“We have several projects at risk.”

to:

“These four projects are forecasted late, two are due this month, and these are the projects we should discuss first.”

That's the difference between reading the dashboard and using it to prioritize action.


Best practices

These are suggested reporting practices rather than product requirements.

Separate current state from forecasted risk

Use Late Projects to understand what is already late.

Use Projects Forecasted Late to identify risk before the planned completion date is missed.

Looking at both provides a more complete portfolio picture.

Use Total Active Projects as context

A risk count is more useful when you understand the size of the portfolio behind it.

Compare late, forecasted-late, or concerning RAG signals with your active-project population before drawing conclusions.

Remember that On Hold remains part of project-level active metrics

For Projects Overview, On Hold projects can remain included in applicable active-project calculations such as Total Active Projects.

Do not assume the same active-population rules used by task reporting apply here.

Review forecasting before the due date

The purpose of forecast information is to give you an earlier signal.

If you only review projects once they become Late, you lose the opportunity to investigate the risk while there may still be time to adjust the plan.

Use working-day configuration when interpreting duration

Project duration is based on your workspace working days.

Keep that configuration in mind when comparing average duration with manually calculated calendar-day timelines.

Use RAG as a starting point, not a diagnosis

A RAG status can help identify which projects deserve investigation.

Review the underlying project context before deciding what caused the health signal or what action is needed.

Use filters before comparing portfolios

A workspace-wide portfolio can combine different:

  • Customer segments

  • Project types

  • Regions

  • Products

  • Delivery motions

Narrow the report before comparing results when those differences matter to your decision.


Frequently asked questions

What is considered an active project?

For Total Active Projects, projects in these categories are excluded:

  • Done

  • Pending

  • Cancelled

On Hold projects are included.

Other widgets may use their own built-in scope, so check the widget definition when comparing metrics.

For a complete widget reference, see the GUIDEreports widget library.

Are On Hold projects included in Total Active Projects?

Yes.

On Hold projects remain included in Total Active Projects.

This differs from some task-focused active metrics, which can exclude tasks belonging to On Hold projects.

Is Not Applicable a project status?

No.

Not Applicable is a task status, not a project status.

What is the difference between Late Projects and Projects Forecasted Late?

Late Projects identifies projects whose current project status category is Late.

Projects Forecasted Late identifies ongoing projects expected to finish later than planned.

One represents a current condition. The other is a forward-looking risk signal.

Can a project be forecasted late before its due date?

Yes.

That is the purpose of forecasting.

A project can be currently in progress and not yet Late while its forecast indicates that expected completion will fall behind the plan.

Are On Hold projects included in forecasting metrics?

Forecasting widgets such as Projects Forecasted Late exclude Done, Cancelled, and Pending projects.

Because On Hold is not one of those exclusions, it can remain in the qualifying population.

How is Avg Project Duration calculated?

Avg Project Duration uses completed projects and reports project duration using the working days configured at the workspace level.

Use it as a historical benchmark for completed project delivery.

Does project duration use calendar days?

No.

Project duration uses the working days configured for the workspace.

What does Cash Value mean?

Cash Value is the value stored on the project.

It may be populated manually or through automation depending on your configuration.

How your organization interprets that field depends on your business process.

Why don't two project widgets show the same number?

Widgets can have different built-in calculations.

For example:

  • Projects Created is a broad project count.

  • Total Active Projects excludes Done, Pending, and Cancelled.

  • Late Projects only counts projects currently categorized as Late.

  • Projects Forecasted Late uses forecasting criteria and its own project-status exclusions.

Check the specific widget definition before assuming the totals should match.

Can I filter Projects Overview to one customer or project type?

Yes.

Use the available GUIDEreports filters to narrow the report.

You can also combine filters such as customer, custom fields, project status, tags, or dates.

How do I see which projects are behind a metric?

If the widget supports a drilldown, hover over it.

When your cursor changes to a pointer hand, select the widget to open the underlying project records.

See the GUIDEreports drilldown field reference for definitions of the fields you may see.

What if Projects Overview doesn't answer the question I need?

First, check whether filters can narrow the Standard report to the portfolio you need.

If not, you can build a custom GUIDEreport using available widgets.

Continue learning about GUIDEreports

Did this answer your question?