Reporting and Dashboards | Entry 80
The reporting question and audience should choose the visualization. HubSpot lets nonprofits present validated data through tables, bars, lines, areas, pies, KPIs, gauges, combination charts, pivots, scatter plots, and purpose-built funnels so the central answer is easier to understand and act on.
A detailed donation table may be ideal for development operations, while a board meeting may benefit from a simple line chart showing revenue growth or a KPI showing progress toward the annual goal.
Similar data can support several valid visualizations, but each style directs attention toward a different insight. The goal is to make the answer easy to understand.
Changing a compatible visualization does not change the report's sources, filters, calculations, or data quality. Those elements still require validation.
Purpose-built report types also have their own logic. A funnel is not a decorative shape that can be applied to unrelated categories. It requires defined, ordered stages and conversion rules.
| Reporting question | Recommended visualization |
|---|---|
| What is the exact value? | KPI or summary |
| Which category performed best? | Horizontal or vertical bar chart |
| How has performance changed over time? | Line chart |
| How do categories contribute to a total over time? | Area chart |
| How is one total divided among a few categories? | Donut or pie chart |
| Which records need attention? | Table |
| How do several dimensions interact? | Pivot table |
| How do differently scaled metrics compare? | Combination chart |
| Is there a relationship between numeric measures? | Scatter plot |
| How close are we to a target? | Gauge or KPI |
| Where do people leave a defined process? | Funnel report |
Tables work when staff need names, amounts, dates, funds, campaigns, statuses, owners, or other record-level details to take action.
Tables show exact values and several fields together, but large tables can overwhelm executives, hide trends, and turn a dashboard into a spreadsheet. HubSpot tables can contain up to 30 fields.
Use horizontal bars for donations by fund, volunteer hours by program, memberships by type, sponsorship revenue by event, or grants by funder, especially when labels are long. They make rankings and top-five or top-ten comparisons easy to scan.
Use vertical bars, also called column charts, for donations by month, registrations by quarter, memberships by year, or applications by campaign. They work well for categories and discrete periods and can show grouped or stacked values.
A fundraising leader asks: what was our average completed donation amount this quarter?
Use a limited number of series. Avoid lines for unrelated categories, distinguish missing data from zero, and keep time intervals consistent so the shape of the trend remains honest.
Area charts work for revenue by source, restricted and unrestricted revenue, enrollment by service, volunteer hours by program, or donations by acquisition channel. Stacked areas can show how categories contribute to an overall total.
Limit categories because overlapping areas can hide smaller series and visual noise can make exact comparisons difficult.
These charts can show donations by designation, members by type, revenue by source, volunteers by status, or attendees by registration category when the values form one meaningful total.
Although HubSpot can display up to 25 pie sections, effective nonprofit reporting will generally use far fewer.
KPI visualizations can highlight fiscal-year revenue, new donors, donor retention, active memberships, volunteer hours, campaign goal attainment, open grants, or average gift size.
A KPI is immediate and useful for executive dashboards, but it may hide variation and cannot explain why a number changed. Pair important KPIs with a trend chart or breakdown report, and avoid filling the dashboard with competing headline values.
Gauges work for annual fundraising, capital campaigns, membership renewal, event registration, volunteer recruitment, or grant pipeline targets. Color bands can show performance ranges.
Use them sparingly. A gauge takes substantial space for one value and needs a real benchmark. Without context, it can imply success or failure too simplistically. HubSpot gauges accept one value field.
A bar-and-line combination with two Y-axes can compare donation revenue with donor count, registrations with attendance rate, marketing spend with donors acquired, membership revenue with renewal rate, or volunteer hours with active volunteers.
Dual axes require clear labels and honest scaling. Combine only related measures because poor scaling or unrelated metrics can create a false relationship. HubSpot currently allows up to four fields in a combination chart.
Pivot tables can summarize donation revenue by fiscal year and fund, memberships by chapter and type, volunteer hours by program and location, attendance by event and constituent category, or grants by funder and status.
They support exact summarized values and subtotals, but complex pivots may belong in analyst workflows rather than executive dashboards. HubSpot pivot tables can contain up to 30 fields, with up to four row fields and four column fields.
Scatter plots can compare donation frequency with lifetime giving, event attendance with subsequent giving, volunteer hours with donor engagement, marketing spend with acquired donors, or program cost with participant outcomes.
They can reveal clusters and outliers, but correlation does not prove causation. Outliers may distort the scale, and unfamiliar audiences may need a brief explanation.
Funnel reports show movement and conversion through processes such as prospect to first-time donor, first-time to recurring donor, volunteer inquiry to approval, invitation to registration to attendance, membership inquiry to activation, grant prospect to award, or sponsorship prospect to agreement.
A funnel is a distinct report type. Its selected logic determines whether records must pass through all chosen stages or qualify through any selected stage.
HubSpot smart chart can review selected fields, highlight compatible styles, suggest a chart, arrange fields into recommended channels, and choose a breakdown. Report builders can then switch it off and manually configure axes, columns, values, and breakdowns.
The recommendation does not replace judgment. The nonprofit must still decide whether the proposed visualization communicates the intended answer.
Donation revenue by month can become a table for exact totals, vertical bars for monthly comparison, a line for the overall trend, an area chart for volume, or a KPI for the period total.
After switching styles, reassign axes and values as needed, review breakdowns and aggregations, reduce fields, adjust settings, and confirm that the new chart supports the selected data. Chart types have different limits and configuration requirements.
| Visualization | What monthly donation data emphasizes |
|---|---|
| KPI | We raised $750,000 this year. |
| Line chart | Revenue increased throughout the year and spiked in December. |
| Bar chart | December generated more revenue than any other month. |
| Stacked area | Year-end growth was driven mainly by individual giving rather than grants. |
| Table | These are the exact monthly totals for every fund and campaign. |
All five views may be accurate. Select the one that supports the intended decision.
| Audience | Useful formats | Primary need |
|---|---|---|
| Operations teams | Tables, pivots, record breakdowns, exception reports | Detail and action |
| Managers | Bars, lines, KPIs, action tables, funnels | Performance and next steps |
| Executives | KPIs, trends, gauges, combinations, focused comparisons | Trends, risks, and progress |
| Board members | Limited KPIs, simple bars or lines, goal progress, year-over-year comparisons | Mission outcomes and strategic context |
A board dashboard should not be an operations dashboard with larger fonts.
HubSpot's available fields, channels, settings, and limits vary by chart type, report builder, and subscription. Current documented limits include up to 12 axis fields in certain bar, line, and area configurations; four fields in a combination chart; one gauge value; up to 30 fields in tables and pivots; up to four pivot rows and columns; and up to 25 displayed pie sections.
Dashboard display may also be limited when breakdowns contain more than 99 values. Confirm current capabilities during implementation.
Effective nonprofit reporting combines dependable data with a visualization suited to the question, decision, and audience. When report builders validate the underlying logic, choose an appropriate format, limit clutter, provide context, and preserve supporting detail, the same data can serve operations, management, executives, and the board without creating confusion.