Skip to main content

Use GUIDEreports: Filters, drilldowns, sorting, and navigation

Learn how to use filters, drilldowns, sorting, and report navigation in GUIDEreports so you can move from a high-level metric to the projects, tasks, customers, or records behind it.

Written by Elan Maynez

Overview

GUIDEreports helps you move from “Something needs my attention” to “Here are the records I need to investigate.”

Reports can include summary cards, charts, tables, filters, and detailed drilldowns. Once you understand how these pieces work together, you can use the same investigation process across nearly every GUIDEreport.

A useful reporting workflow is:

Start broad → narrow the data → identify a signal → drill into the records → take action


Start with the question you want to answer

Before applying filters or opening a drilldown, decide what you are trying to understand.

For example:

  • Which projects are currently at risk?

  • Which customers have overdue work?

  • What tasks are blocking project progress?

  • Which projects are forecasted to finish late?

  • How much time did a particular team member log?

  • What did customers say in recent CSAT responses?

Starting with a question makes it much easier to choose the right report, metrics, and filters.

Instead of asking:

“What does this dashboard tell me?”

Try asking:

“Which projects need my attention this week?”

Then use the report to find the answer.


Filter your report

Filters narrow the data included in a report so you can focus on the customers, projects, tasks, dates, or other criteria that matter to your question.

Instead of reviewing your entire portfolio, you might filter a report to:

  • One customer

  • Projects with a particular status

  • Tasks with a particular responsibility

  • Work due within a specific period

  • Projects or tasks associated with particular tags

  • Records matching your project or task custom fields

The widgets on the report update to reflect the data matching your selected filters while still following each widget's individual calculation rules.

Available filters

Most GUIDEreports use the same report-level filters:

  • Customer — Focus on a specific customer or account.

  • Project/Task Custom Fields — Narrow your results using the project or task information your organization tracks.

  • Project Status — Focus on projects based on their current status.

  • Task Status — Narrow the report based on the current status of tasks.

  • Project Tags — Focus on projects associated with specific tags.

  • Task Tags — Focus on work associated with particular task tags.

  • Task Responsibility — Narrow tasks based on whether responsibility belongs to Internal, Customer, or Partner.

  • Task Start Date / Due Date — Focus on tasks based on when they start or are due.

  • Project Start Date / End Date — Narrow results based on project dates.

Date filters include options for common reporting periods as well as custom date ranges.

Important Note:

Advanced Time Reporting includes all of the standard GUIDEreports filters plus:

  • Date Worked

  • Time Entry Member

These additional filters let you narrow time-entry reporting based on when the work occurred or who logged the time.

Users Overview does not have report-level filters.

Because this report focuses on workspace-user records rather than project or task activity, the standard GUIDEreports filters are not available.

Combine filters to answer specific questions

Filters become especially useful when you combine them.

For example, imagine an onboarding manager preparing for a customer call about delayed work.

They could filter the report to:

  • Customer: Acme

  • Task Responsibility: Customer

  • Task Status: In Progress or Stuck

Instead of looking at all task activity, the report now helps answer a much more useful question:

Which customer-owned tasks for Acme currently need attention?

Or a delivery leader might combine:

  • Project Status: Late

  • Project Custom Field: Enterprise

  • Project End Date: This Quarter

Now the question becomes:

Which enterprise implementations ending this quarter are currently late?

Tip: Filter to the population you actually want to evaluate before comparing results. Workspace-wide numbers can combine very different customers, project types, teams, and delivery motions.

Understand what happens when you apply a filter

Think of a report filter as changing the population you are asking GUIDEreports to analyze.

For example, imagine Total Active Projects shows 74 projects.

If you filter the report to a particular customer, you are no longer asking:

“How many active projects do we have?”

You are now asking:

“How many active projects match this customer filter?”

The same principle applies when filtering by status, responsibility, tags, custom fields, or dates.

This is especially important when sharing report results with someone else.

Before presenting a number, check the active filters so everyone understands the population that number represents.


Move from summary to detail

Different parts of a GUIDEreport help answer different levels of your question.

Summary cards tell you how much

A summary card might show:

  • 14 overdue tasks

  • 7 late projects

  • 6 stuck customer tasks

  • 4 projects forecasted late

These numbers are useful signals.

But a number usually tells you that something deserves attention — not necessarily why.

Charts help show where

Charts can help you understand where a result is concentrated.

For example, an overdue-work chart might show which projects have the largest number of overdue tasks and how those tasks are distributed by status.

That changes the question from:

“Do we have overdue work?”

to:

“Where is our overdue work concentrated?”

Drilldowns show you the individual records

A drilldown lets you investigate the records behind a metric or visualization.

Depending on the report, those records might represent:

  • Projects

  • Tasks

  • Customers

  • Team members

  • Time entries

  • CSAT responses

Tip: A helpful way to think about GUIDEreports is:

Card = How much?

Chart = Where?

Drilldown = Which records?

Know which widgets have a drilldown

Not every GUIDEreports widget is clickable.

To see whether a widget supports a drilldown, hover your cursor over it.

If your cursor changes to a pointer hand, you can select the widget to open its drilldown.

If your cursor does not change to a pointer, that widget does not have an available drilldown.


Use drilldowns to investigate a result

Suppose Stuck Tasks shows 12.

That number tells you how much blocked work exists based on the widget calculation and your current filters.

Your next question probably isn't:

“Is 12 a big number?”

A more useful question is:

“Which 12 tasks are stuck, who owns them, and which projects are affected?”

Open the drilldown to investigate the individual records contributing to the result.

Depending on the report, drilldown fields can include information such as:

  • Task or project name

  • Customer

  • Responsibility

  • Assignee

  • Status

  • Start and due dates

  • Whether work is overdue

  • Forecast information

  • Status explanations

  • Milestones

  • CSAT response details

  • Time-entry information

The exact fields depend on the report and the type of data being investigated.

See GUIDEreports drilldown field reference for more information about the fields available across GUIDEreports.

Sort drilldown results

Every column header in a GUIDEreports drilldown table is sortable.

Select a column header to sort the table A → Z or Z → A. Select it again to reverse the order.

Sorting is especially useful when a drilldown contains many records.

For example, you might sort by:

  • Project name

  • Customer

  • Assignee

  • Status

  • Due date

  • Date created

  • Date updated

  • Another available field

Sorting does not change which records are included in the drilldown. It changes the order in which you review them.

This can make it much easier to find patterns or prioritize the records you want to investigate first.


Example: Investigate overdue customer work

The following is an illustrative onboarding scenario.

Your weekly delivery review shows an increase in overdue customer tasks.

Instead of immediately contacting every customer, you can use GUIDEreports to narrow the problem.

1. Start with the signal

The Overdue Customer Tasks metric tells you that customer-owned work is past due.

2. Narrow the report

Apply filters for the customers, projects, or other criteria included in your review.

3. Look for concentration

Use the available project-level charts or other visualizations to determine whether the overdue work is spread across many projects or concentrated in a few.

4. Open a drilldown

If the widget supports drilling down, hover over it and look for the pointer cursor.

Open the drilldown to identify the individual tasks contributing to the result.

5. Sort the records

Sort the drilldown by a column that helps with your investigation.

You may discover that:

  • Several overdue tasks belong to the same project

  • One customer has multiple overdue action items

  • Some work is already in progress

  • Other work has not started

  • Some tasks do not have an assignee

6. Decide what needs action

Now your team's conversation can be specific.

Instead of:

“We have a lot of overdue customer work.”

you might determine:

“Most of our overdue customer work is concentrated in two implementations, so let's review those projects first.”

That is the difference between simply reading a dashboard and using the report to make a decision.


Understand why widgets can show different numbers

Two widgets on the same report do not necessarily measure the same population.

Each widget has its own calculation and inclusion rules.

For example, one metric might count all projects, while another counts only projects meeting a particular status or timing requirement.

One task widget might include all tasks, while another might only include:

  • Active work

  • Customer-owned tasks

  • Overdue tasks

  • Specific task statuses

  • Tasks due within a particular period

This means the same report filters can apply to multiple widgets while those widgets still return different totals.

That does not mean one of the widgets is incorrect.

They may simply answer different questions.

Use the article for the standard report or the GUIDEreports widget library when you need to understand exactly what a widget includes.

Example: Total Tasks versus Active Tasks

Imagine a report shows:

Total Tasks: 2,450

and

Active Tasks: 620

These are not two competing answers to the same question.

Total Tasks answers a question about overall task volume.

Active Tasks answers a question about the work that currently qualifies as active based on that widget's calculation.

Instead of asking:

“Which number is right?”

ask:

“What question is each metric answering?”

Both numbers can be correct.


A simple workflow for reviewing GUIDEreports

You do not need to review every card, chart, and table every time you open a report.

Try this workflow instead.

1. Identify your question

For example:

Which active projects need attention this week?

2. Choose the right report

Start with the report that most closely matches your question.

For example, Projects Overview can help with portfolio health, while Task Management can help you investigate task-level delivery problems.

3. Apply your filters

Narrow the report to the customers, projects, statuses, responsibilities, dates, or other criteria relevant to your review.

4. Scan for signals

Focus on the metrics and charts related to your question.

You do not need to interpret every widget on the report.

5. Find the outliers

Look for work that appears late, stuck, unusually high, or otherwise worth investigating.

6. Drill into the details

When a widget supports a drilldown, use it to identify the underlying records.

7. Sort the results

Use the drilldown's sortable column headers to organize the records around your investigation.

8. Decide what happens next

Your next action might be to:

  • Follow up with a customer

  • Reassign work

  • Review a project plan

  • Unblock a task

  • Discuss a risk with the project manager

  • Investigate a recurring delivery pattern

GUIDEreports helps you find where to look. Your team can then decide what action makes sense based on the underlying work.


Best practices

These are suggested reporting practices rather than product requirements.

Start with one question

Avoid opening a report and trying to understand everything at once.

A question such as:

“Which projects are at risk of missing their target date?”

gives the review a clear purpose.

Check your filters before sharing a number

A metric filtered to one customer means something very different from the same metric across your full portfolio.

Always check the report scope before presenting a number as an organization-wide result.

Investigate before drawing conclusions

A high number of stuck or overdue tasks tells you something deserves attention.

It does not automatically explain the cause.

Use the available drilldown and underlying project information before deciding why the work is delayed.

Move from broad to specific

Start with the report, narrow it with filters, identify the signal, and then move into the individual records.

This is often much faster than beginning with individual projects or tasks.

Compare widgets only when you understand what they measure

Widgets with similar names can still use different inclusion rules.

Check the widget definition when the difference is not obvious.

Build reviews around decisions

Instead of asking your team to “go through the dashboard,” start with a question such as:

Which customers need follow-up before the end of the week?

or

Which late projects require intervention?

The report becomes more useful when it supports a specific decision.


Frequently asked questions

Do filters affect the whole report?

Report-level filters narrow the data being analyzed by the report.

Each widget still follows its own calculation, so two widgets can return different totals even when the same filters are applied.

Can I use more than one filter at a time?

Yes.

Combining filters lets you focus on a more specific group of records.

For example, you could combine Customer, Project Status, Task Responsibility, and a date filter to investigate a specific type of work.

Keep in mind that each additional filter narrows the data included in the report.

Why did all my numbers change after I applied a filter?

You changed the population being analyzed.

For example, Total Active Projects across the full workspace and Total Active Projects after filtering to one customer answer different versions of the same question.

Check the active filters whenever a number looks different from what you expected.

Why am I seeing very little data after adding several filters?

Your combination of filters may be very narrow.

Review your active filters and remove them one at a time to see which condition is limiting the results.

This is especially helpful when you're combining statuses, dates, custom fields, and other criteria.

Why don't two widgets on the same report have the same total?

Widgets can use different calculations and inclusion rules.

One might include all records, while another includes only active work, a particular responsibility, certain statuses, or a specific date period.

Before comparing two metrics, check what question each widget is designed to answer.

How can I tell whether I can drill into a widget?

Hover your cursor over the widget.

If your cursor changes to a pointer hand, the widget supports a drilldown.

If the pointer does not appear, the widget does not have an available drilldown.

Does every widget have a drilldown?

No.

Some widgets can be opened to show underlying records, while others cannot.

Use the cursor behavior to identify which widgets support drilling down.

How do I find the records behind a number?

If the widget supports a drilldown, select it to open the underlying records.

You can then use the drilldown fields and sortable column headers to investigate the individual projects, tasks, users, time entries, CSAT responses, or other records represented by that widget.

Can I sort the drilldown table?

Yes.

Every drilldown column header is sortable.

Select a column header to sort A → Z or Z → A, and select it again to reverse the order.

Does sorting change the report calculation?

No.

Sorting changes the order of the records in the drilldown. It does not change which records are included in the result.

Should I filter first or drill down first?

It depends on what you already know.

If you know the population you want to investigate — for example, one customer — filtering first can make the report easier to review.

If you do not know where the issue is concentrated, start broad. Use the summary metrics and charts to find a signal, then drill into the underlying records.

Why isn't a project or task I expected showing up?

Start by checking:

  • Your active filters

  • The widget's calculation

  • The project's status

  • The task's status or responsibility, when applicable

  • Any relevant date criteria

A record can exist in GUIDEcx without qualifying for every widget.

What should I check if a report number looks wrong?

Start with the report context before assuming the data is incorrect.

Check:

  1. Which report you are using

  2. Your active filters

  3. What the widget is designed to calculate

  4. The records in the available drilldown

These checks can often explain why the result differs from what you expected.

If the underlying records still do not appear to match the widget's documented calculation, note the report, widget, active filters, and example records so the behavior can be investigated further.

Does a high number automatically mean something is wrong?

No.

For example, a high number of active tasks could simply reflect a large active project portfolio.

Metrics are signals. Use related charts, filters, and drilldowns to understand the context before deciding whether action is needed.

What is the difference between a report filter and a widget calculation?

A report filter determines which data you are asking the report to analyze.

A widget calculation determines which records from that data qualify for a particular metric.

For example:

Filter: Show me only Enterprise customers.

Widget calculation: Within those customers, count projects that are forecasted late.

Both affect the result, but they do different jobs.

Why does Advanced Time Reporting have more filters?

Advanced Time Reporting includes all standard GUIDEreports filters plus Date Worked and Time Entry Member.

These filters are specific to time-entry reporting and let you narrow results based on when work occurred or who logged it.

Why can't I filter Users Overview?

Users Overview does not have report-level filters.

It reports on workspace-user records rather than using the standard project- and task-based filtering experience.

What should I do if a standard report doesn't answer my question?

First, see whether the report's filters can narrow an existing standard report to the information you need.

If it still does not answer your question, you can create a custom GUIDEreport using the available widgets.

See Build a custom GUIDEreport to learn how report building works, and use the GUIDEreports widget library to understand what each available widget measures.

Keep learning about GUIDEreports

Use these resources depending on what you want to do next:

  • GUIDEreports overview — Choose the right reporting experience or standard report for your question.

  • Standard report articles — Understand the metrics, calculations, and workflows for a specific report.

  • GUIDEreports access, report types, and permissions — Understand who can view, create, and manage different report types.

  • Build a custom GUIDEreport — Create a report for a question not covered by the standard reports.

  • GUIDEreports widget library — Learn what each widget shows, how it is calculated, and when to use it.

  • GUIDEreports drilldown field reference — Understand the fields available in report drilldowns.

Did this answer your question?