Loading

Lightning Table Dashboard Component Shows Different Values for Measures from Source Report

Date de publication: Jun 21, 2026
Description

Lightning Table dashboard components use the objects, fields, and filters of the underlying source report, but groupings and measures can be shown in the component independent of its report. In circumstances where the source report contains multiple objects, measures may return different values from the source report if child object fields have not been included in the component; therefore, the count is performed on the parent object.
Note: The measure may not update to the different value until after the dashboard is refreshed.


Example: A Lightning Table component could be using an "Accounts with Opportunities" report type. Adding a grouping on Account Name and using Record Count as the only measure will result in the Lightning Table ignoring Opportunity records and counting the number of records that exist on the Account object for each Account Name. Assuming that there are no duplicate Account records, the Record Count for each row would be 1.

Résolution

Resolving Measure Discrepancies in Lightning Table Dashboard Components

When a Lightning Table dashboard component returns measure values different from its source report, this is typically because the component is counting records on the parent object rather than the intended child object. This can be resolved using one of the following approaches:

 

  • Add a field from the child object to the dashboard component.
  • Use a different report type wherein the child object from the previous report is the primary object. Following from the above example, group by the Account Name field from an "Opportunities" report instead of using an "Accounts with Opportunities" report.
  • Add a number formula field to the child object and set it equal to 1 (this is also sometimes called a "Power of One" field), then summarize the field in the Lightning Table instead of using Record Count.
Numéro d’article de la base de connaissances

000382344

 
Chargement
Salesforce Help | Article