Skip to content
Tutorials Center
My learning

Topics

Lesson 28 of 37 ยท Reporting and Dashboards

Dashboards and Single-Object Reports in HubSpot

Learn how HubSpot dashboards, report libraries and single-object reports work: chart types, filters, groupings, sharing and good KPI design, with runnable aggregation stand-ins.

A CRM full of data is only useful if people can see what it says. HubSpot's reporting tools turn records into charts and tables, and dashboards gather those charts on one page for a team. This lesson covers the building blocks: the dashboard, the report library, and the simplest reports, those based on one object such as deals or tickets.

HubSpot is not available on this site. Python snippets are stand-ins that perform the same grouping and summing a report does, using sample data. The number of dashboards and reports you may create depends on your plan.

Dashboards

Open Reporting > Dashboards. A dashboard is a page of report widgets and can be set to private, shared with everyone, or shared with specific teams. You can:

  • start from the dashboard library (sales, marketing, service templates),
  • add reports from the report library or create new ones,
  • apply a dashboard filter (date range, owner, team) that changes every report at once,
  • set a default dashboard per team so people land on it,
  • schedule email delivery of a dashboard snapshot.

Good dashboards answer one audience's questions: a sales manager's dashboard shows pipeline, forecast and activity; a support lead's shows open tickets, time to first response and CSAT. Ten to twelve reports is plenty.

Single-object reports

Under Reporting > Reports > Create report > Single object, choose an object and a chart type. The configuration has four parts:

  1. Data source: the object (deals, contacts, tickets ...).
  2. Chart type: bar, column, line, area, donut, pie, table, KPI (single number), pivot table, funnel.
  3. Measure (Y-axis): count of records, or a sum/average/min/max of a numeric property such as Amount.
  4. Grouping (X-axis): a property such as Deal stage, Close date by month, or Owner. A second grouping creates stacked series.
  5. Filters: record-level rules such as "Create date is in this quarter".

Report anatomy

Object Deals, contacts, tickets
Measure Count, sum, average
Group by Stage, owner, month
Filter Date range, pipeline

One question per chart

1 / 2

What a report really computes

A bar chart of "deal amount by stage" is a grouped sum. You can reproduce it yourself, which helps when numbers look wrong.

Python Sum and count of deals by stage

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

A second grouping

Adding "Owner" as a second grouping gives a stacked chart: each stage bar is split per owner.

Python Pivot: stage by owner

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Choosing chart types

Question Chart
One headline number KPI
Trend over time Line or column by month
Parts of a whole (few parts) Donut
Compare categories Bar
Stage drop-off Funnel
Exact values Table

Avoid pie charts with many slices and avoid dual axes when a table would be clearer.

Date logic that surprises people

  • Create date versus Close date: a deal created in March that closes in May appears in different months depending on the property.
  • Reports use the portal time zone and fiscal-year settings when set.
  • A filter "close date is this month" excludes deals with an empty close date.
  • Records can be filtered by pipeline; forgetting it mixes unrelated stages.
Python Group by close month

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Design habits

  • Title each report with the question and unit: "Open tickets by priority (count)".
  • Use the same date range on a dashboard; put the filter at the top.
  • Keep names consistent with your team's definitions (what is a "qualified" deal?).
  • Share read-only views widely and restrict edit rights.

Reports built from more than one object, or those tracking revenue sources, need the custom report builder: see custom reports and attribution.

Check your understanding

Quick check ยท 3 questions

of 3 answered You scored / 3 ยท perfect!

  1. 1. What is a dashboard filter good for?

    Dashboard filters apply to all compatible reports so the whole page answers one question.
  2. 2. A bar chart of deal amount by stage is computed as...

    The measure is a sum and the grouping is the stage.
  3. 3. Why can a deal appear in different months in two reports?

    The date property chosen for the grouping determines the month.

Summary

  • Dashboards combine reports for a specific audience; filters apply globally.
  • A single-object report = object + chart + measure + grouping + filters.
  • Understand date properties and pipelines to avoid misleading charts.
  • Match chart type to the question and keep dashboards small.

Next: Custom Report Builder and Marketing Attribution