Skip to main content

Standard report: Historical Trends

Learn how to use the GUIDEreports Historical Trends report to review changes in project volume, completion, duration, customer participation, satisfaction, and other delivery patterns over time.

Written by Elan Maynez

Overview

The Historical Trends report helps you understand how your onboarding and Professional Services performance is changing over time.

While reports such as Projects Overview focus heavily on the state of projects today, Historical Trends is designed for a different question:

Are our delivery patterns improving, declining, or staying consistent over time?

Use this report to look beyond a single current-state number and identify longer-term patterns that may be difficult to see in individual projects.

What you can learn from this report

Historical Trends can help you investigate questions such as:

  • Is project volume increasing or decreasing?

  • Are we completing more projects than we were previously?

  • Are implementations taking more or less time?

  • Are project-start and project-completion patterns moving together?

  • Is customer participation changing?

  • Are customer-feedback trends improving or declining?

  • Are there meaningful changes that deserve a deeper look in the underlying projects?

The report is especially useful for monthly, quarterly, and leadership reviews where direction over time matters more than one snapshot.


Filter the report

Historical Trends uses the standard GUIDEreports filters.

These include:

  • 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

Filters let you compare trends for the population you actually care about.

For example, you could narrow the report to:

  • One customer segment

  • A particular implementation type

  • Projects associated with a specific tag

  • Work within a selected date range

  • A particular project-status population

That lets you move from:

“Are our projects getting faster?”

to a more specific question such as:

“Are Enterprise implementations getting faster?”


Understand the difference between current state and historical trends

This distinction is the most important part of using the report correctly.

View

Question it answers

Current-state metric

What is true right now?

Historical trend

How has this changed over time?

For example:

Completed Projects tells you how many projects are currently represented as complete within the applicable reporting scope.

A completion trend tells you how completed-project volume has changed across successive periods.

Neither is inherently better.

They answer different questions.

Tip: Use Historical Trends when you're trying to understand direction and patterns. Use a current-state Standard report when you're trying to decide what needs attention today.


Understand project intake trends

Project-creation and project-start trends help you understand how the amount of incoming work changes over time.

Widget

What it shows

Projects Created (12m)

Number of projects created during the last 12 months.

Projects Created By Month (12m)

Number of projects created each month during the last 12 months.

Projects Started By Month Break By Status Last 12 Months

Projects started each month during the last 12 months, broken down by project status.

Projects Created By Month (12m)

Question it answers: Is our incoming project volume changing?

Use the monthly trend to identify periods where project creation rises, falls, or remains relatively consistent.

This can help provide context for other delivery trends.

For example, if project duration begins increasing during the same period that incoming volume increases sharply, that may be worth investigating.

The chart does not prove that higher volume caused longer delivery.

It simply helps you identify patterns that may deserve a closer look.

Projects Started By Month Break By Status Last 12 Months

Question it answers: What happened to the projects that started during different periods?

This view combines:

  • Project start timing

  • Project volume

  • Current project status

Use it to understand whether projects started during different months are now represented differently across project statuses.

For example, a cluster of older projects that remain active may deserve further investigation.


Understand project completion trends

Completion trends help you understand how work is moving out of the delivery portfolio.

Widget

What it shows

Projects Completed (12m)

Projects completed during the last 12 months.

Projects Completed By Month (12m)

Completed projects grouped by completion month during the last 12 months.

Projects Completed Details (12m)

Detailed project records for projects completed during the last 12 months.

Projects Completed By Month (12m)

Question it answers: How is our completed-project volume changing month to month?

Use this trend alongside project creation or start trends.

Looking at the two together can help you understand whether project inflow and completion volume appear to be moving in similar or different directions.

For example:

  • Project starts increasing while completions remain stable

  • Completions increasing while starts remain stable

  • Both rising together

  • Both declining

Each pattern creates a different question for the delivery team to investigate.

Projects Completed Details (12m)

Use the detailed completion view when the trend tells you something changed and you need to understand which projects contributed to that result.

Project records can provide context such as:

  • Customer

  • Project manager

  • Status

  • Dates

  • Duration

  • Phase information

This is the bridge between the historical pattern and the underlying projects.


Understand project-duration trends

Duration trends help you understand whether completed projects are generally taking more or less time.

Widget

What it shows

Avg Project Duration (12m)

Average duration of projects completed during the last 12 months.

Avg Project Duration By Month (12m)

Average project duration grouped by completion month during the last 12 months.

Avg Project Duration By Month (12m)

Question it answers: Are completed implementations getting faster or slower?

Use the monthly view to identify changes in delivery duration over time.

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

That matters when interpreting the numbers.

Do not compare the displayed duration directly with manually counted calendar days unless your working-day configuration matches the calendar.

How to interpret a duration change

If average duration increases, avoid jumping directly to a conclusion.

The change could coincide with differences in:

  • Customer segment

  • Project scope

  • Implementation type

  • Project volume

  • Process design

  • Customer participation

  • Other characteristics of the filtered portfolio

Use filters and the project drilldown to investigate which projects are contributing to the pattern.


Compare project intake and completion

One of the most useful ways to use Historical Trends is to compare related trends instead of reading each chart independently.

Compare

Question to investigate

Projects Created vs. Projects Completed

Is incoming volume changing at the same pace as completed volume?

Projects Started vs. Avg Project Duration

Are delivery durations changing during periods of higher or lower project starts?

Completion volume vs. duration

Are we completing more projects while maintaining similar delivery timing?

These comparisons identify patterns.

They do not establish cause.

Use them to decide where deeper analysis would be valuable.


Review customer-participation trends

Historical customer-participation views can help you understand whether the makeup of the customer team involved in implementations is changing.

Widget

What it shows

Avg. Customers Invited (12m)

Average number of external project members associated with qualifying projects during the last 12 months.

Avg. Customers Invited by Month (12m)

Average customer participation by month during the last 12 months.

Use the monthly view to investigate questions such as:

Are newer projects involving more customer stakeholders than projects earlier in the year?

A rising number is not automatically positive, and a falling number is not automatically negative.

Different implementation models may require different levels of customer participation.

Treat this as a description of the delivery motion rather than a universal engagement score.


Review messaging trends

Historical messaging views can help you understand how customer-facing communication changes over time.

Widget

What it shows

Public Messages Created (12m)

Public or external messages created during the last 12 months.

Public Messages Created by Month (12m)

Public or external messages grouped by month during the last 12 months.

Use the monthly trend when you care about direction, rather than only the total number of messages.

For example, a significant change in messaging activity may be worth comparing with changes in:

  • Project volume

  • Customer participation

  • Duration

  • Delivery process

Again, the report identifies a pattern — not the reason for it.


Review satisfaction trends

Historical CSAT trends help you understand whether customer sentiment is changing over a longer period.

Widget

What it shows

Overall CSAT Avg Rating Score Trend (12m)

Average CSAT rating score by response month during the last 12 months.

Project CSAT Avg Rating Score Trend (12m)

Average rating score for project-level surveys by response month.

Milestone CSAT Avg Rating Score Trend (12m)

Average rating score for milestone-level surveys by response month.

Use CSAT trends to identify direction

A single CSAT score gives you one point of reference.

A trend helps answer:

Is satisfaction generally moving up, down, or remaining stable?

For example, if project duration improves while satisfaction declines, the team may want to investigate whether faster delivery is still producing the expected customer experience.

The trend does not prove those changes are related.

It tells you where additional investigation may be worthwhile.

For deeper survey-response analysis, use the CSAT Standard report.


Review time trends

Time trends can help you understand whether tracked delivery effort is changing.

Widget

What it shows

Total Hours Worked Over Time (12m)

Total tracked time grouped by month based on Date Worked during the last 12 months.

Total Hours Worked By Person (12m)

Total tracked time by team member over the last 12 months.

Use time trends alongside project volume and duration when you need additional delivery context.

For example, increasing tracked time during a period of increasing project volume may be expected.

A time trend becomes more useful when it is interpreted alongside the work being delivered.

For deeper time-entry analysis, use Advanced Time Reporting.


Drill into the projects behind the trend

Historical Trends uses the project-oriented drilldown structure also used by Projects Overview.

Depending on the widget, project records can include fields such as:

  • Project Name

  • Customer Name

  • Start Date

  • Due Date

  • Done Date

  • Forecasted End Date

  • Cash Value

  • Duration Days

  • Planned Duration Days

  • Forecasted Duration Days

  • Forecasted Variance Days

  • Phase Names

  • Milestone Names

  • Status Label

  • RAG information

Every drilldown column header can be sorted A → Z or Z → A.

For complete definitions, see the GUIDEreports drilldown field reference.


Example: Prepare for a quarterly operations review

The following is an illustrative Professional Services scenario.

A delivery leader is preparing for a quarterly review.

The leadership team wants to know:

Are we scaling delivery without making implementations slower or hurting the customer experience?

1. Review incoming volume

They start with:

  • Projects Created By Month (12m)

  • Projects Started By Month Break By Status Last 12 Months

Project volume has increased over several months.

2. Compare completion volume

Next, they review:

  • Projects Completed By Month (12m)

Now they can see whether completed-project volume is changing alongside project intake.

3. Review delivery duration

They check:

  • Avg Project Duration By Month (12m)

If project volume has increased while average duration remains stable, that tells a different story than increasing volume alongside sharply increasing duration.

4. Review customer participation

They review:

  • Avg. Customers Invited by Month (12m)

This helps the team understand whether the customer-team structure involved in projects is changing.

5. Add customer sentiment

They review the available 12-month CSAT trend.

Now the team can compare delivery trends with customer feedback.

6. Investigate the underlying projects

If one month stands out, they use the project drilldown to review the projects contributing to that period.

The conversation moves from:

“Average duration went up.”

to:

“Average duration increased during these months, and these are the projects and customer segments contributing to that change.”

That's the purpose of Historical Trends: turning movement over time into a focused investigation.


Best practices

These are suggested reporting practices rather than product requirements.

Look at direction, not one isolated point

A single high or low month can be useful, but a repeated pattern is usually more informative.

Review several periods before concluding that a delivery motion has materially changed.

Compare related trends

Project volume, completion, duration, customer participation, satisfaction, and effort can provide useful context for one another.

Use related trends together when investigating change.

Don't confuse correlation with cause

Two metrics moving at the same time does not prove one caused the other.

Use the report to identify relationships worth investigating, then review the underlying projects.

Filter before comparing different delivery motions

If your workspace contains very different project types, an overall trend may combine populations that are not useful to compare directly.

Use custom fields, customers, tags, or other filters to narrow the population before drawing conclusions.

Use the drilldown when a period stands out

A chart tells you when something changed.

The drilldown helps you identify which projects contributed.

Move to record-level investigation before deciding what operational change is needed.

Keep working-day configuration in mind

Project-duration reporting uses your workspace working-day configuration.

Remember that when comparing historical duration values with other manually calculated timelines.

Use current-state reports for today's action list

Historical Trends is best for patterns.

If you need to know which projects require intervention right now, use a report such as Projects Overview or PM Command Center.


Frequently asked questions

What is the main difference between Historical Trends and Projects Overview?

Projects Overview helps you understand the current project portfolio and identify present or forecasted project risk.

Historical Trends helps you understand how delivery measures change over time.

Use one for current state and the other for direction over time.

Does Historical Trends use the same filters as other Standard reports?

Yes.

It uses the standard GUIDEreports filters.

Why should I compare project creation and completion trends?

Looking at both can help you understand whether incoming project volume and completed-project volume appear to be moving together or differently.

The comparison identifies a pattern. It does not by itself establish whether capacity is sufficient or explain why the pattern occurred.

Does a longer Avg Project Duration mean our process is getting worse?

Not necessarily.

Duration can vary with differences in project scope, customer type, implementation motion, or other characteristics of the project population.

Use filters and the drilldown to investigate the projects behind the change.

Does a higher Avg Customers Invited value mean better engagement?

No.

It describes customer participation structure, not the quality of engagement.

Different projects may require different numbers of customer stakeholders.

Can I use Historical Trends for one customer or segment?

Yes.

Apply report filters to narrow the trend to the population you want to analyze.

This is especially useful when workspace-wide trends combine different implementation motions.

Can I see the projects behind a historical result?

When a widget supports a drilldown, hover over it.

If your cursor changes to a pointer hand, select the widget to open the available underlying records.

For field definitions, see the GUIDEreports drilldown field reference.

Where can I find the exact calculation for a widget?

The widget library is the central reference for built-in widget scope and calculation behavior.

What if I need a trend that isn't included?

First, check the GUIDEreports widget library for another available trend widget.

If the available Standard report does not answer your question, you can build a custom GUIDEreport using the widgets available in GUIDEreports..

Continue learning about GUIDEreports

Did this answer your question?