Record-Aware Charts in Salesforce: show the right numbers on every record
Published on November 12, 2026 Custom Lightning Report Chart
| Who this is for: Salesforce admins, business analysts and team leads in any industry who want each record page to show charts about that record, not the whole company. |
The problem
A normal report chart answers: "What does the whole business look like?"
Your users usually ask a different question: "What does this customer (or project, patient, property, vendor, student, case) look like?"
| Without record-aware charts, people open a record and then jump to a dashboard to filter it by hand. They copy numbers into slides. Or they ask an admin to build another report for every account. |
What "record-aware" means
The chart reads the page it sits on and filters itself automatically. Open Account A and the chart shows Account A's data. Open Account B and the same chart shows Account B's data.
| One report, one chart component, thousands of records. |
How it works
- You build one Summary report with a filter on the link to the record (for example, Account Name).
- You drop the Custom Report Chart (LWC) onto the record page and enter the report name.
- When a user opens a record, the component passes that record's Id (or a field you choose) into the report's filter.
- The chart draws only that record's data.
| Tip: You can also feed a second filter from a different field on the record, for example Region or Fiscal Year. Extra rules can go in the advanced filter box. |
Benefits for end users
- No hunting. The numbers are on the page they are already on.
- Always the right record. No manual filtering, so no wrong-customer mistakes.
- Faster conversations. A customer call or review starts with the visual already in front of you.
- Fewer reports to maintain. One report serves every record.
- Easy to change. Chart type, sorting and top-N are page settings. No report edits needed.
Use cases by industry
These are examples of the pattern. Each assumes a Summary report with the right grouping.
| Industry | Record page | Example charts |
| Sales and professional services | Account | Opportunities by Stage, Revenue by Product, Quotes by Status |
| Sales and professional services | Project or SOW | Hours by role or phase, estimated vs actual |
| Sales and professional services | Partner | Referred deals by stage and value |
| Customer support and success | Account | Cases by Priority and Status, open vs closed trend |
| Customer support and success | Contact | Cases by product area |
| Customer support and success | Renewal view | License or subscription usage by product |
| Financial services and insurance | Client household | Accounts or policies by type and value |
| Financial services and insurance | Advisor | Clients by risk profile |
| Financial services and insurance | Claims record | Payments by category |
| Healthcare and life sciences | Patient or member | Visits by type, care plan tasks by status |
| Healthcare and life sciences | Provider | Referrals by specialty |
| Healthcare and life sciences | Trial site | Enrolments by status |
| Manufacturing and supply chain | Customer | Orders by product family |
| Manufacturing and supply chain | Supplier | Deliveries by status, defects by category |
| Manufacturing and supply chain | Order | Line items by value |
| Real estate and construction | Property or building | Maintenance requests by category |
| Real estate and construction | Project | Costs by phase, tasks by status |
| Real estate and construction | Landlord or client | Leases by expiry month |
| Education and non-profit | Student or applicant | Activities or applications by stage |
| Education and non-profit | Donor | Gifts by campaign or fund |
| Education and non-profit | Programme | Participants by outcome |
| Retail, hospitality and travel | Customer profile | Orders or bookings by category |
| Retail, hospitality and travel | Store or property | Complaints by type |
| Retail, hospitality and travel | Loyalty | Points by activity |
| IT and software | Customer | Licences, tickets and incidents by status |
| IT and software | Release or sprint | Work items by status and owner |
| IT and software | Vendor | Contracts by renewal date |
Choosing a chart type
| Question | Chart |
| "How is it split?" (share of total) | Pie or doughnut |
| "How do these compare?" | Bar or horizontal bar |
| "How has it changed over time?" | Line |
| "What are the top few?" | Bar with sort and a max count |
| "I want the page to feel premium" | 3D bar, 3D cylinder |
What to prepare
- A Summary report that groups rows by what you want to see (stage, status, month, owner).
- A filter on the field that connects the report to the record page's object.
- Report folder access for every user who will see the chart.
Good practice
| Keep it to 2 to 4 charts per record page. Too many and none gets read. | Give each chart a clear title that says what it answers, such as "Open Cases by Priority". | Use a sort and a top-N limit when a chart has many bars. | Check each chart on a record with no data to see what users get. | Keep reports in a shared folder with a clear name, so the right one is easy to find. |
Where it shows up
Record pages, home and app pages, flow screens and Experience Cloud sites. A support portal can show customers their own usage and orders using the same pattern.
Honest limits
| It charts Summary reports. Matrix reports and plain row listings are not supported yet. | What a user sees depends on their report access. | Very large reports can be slow. Filter by the record to keep them fast. |
Summary
| Record-aware charts turn a record page from a list of fields into a picture of the relationship. Users get the context they need on the page they already use, and admins maintain one report instead of dozens. |
Knowledge Article Number: KA-00501