SECTIONSViewing Lens Data Details
The number of query rows a report retrieves is controlled by the Query Row Limit field on the Report Builder Settings custom setting. If a report's data exceeds this limit, the rows over the limit are not included, so a report might show incomplete data. You can view the lens data details to understand how much data your report retrieved and displayed. This helps you determine why some rows might be missing.
A report retrieves data up to the Query Row Limit, which defaults to 100,000 rows and can be set as high as 999,999. Each lens uses the same limit, so the limit set on an individual lens in Analytics Studio doesn't reduce the number of rows your report retrieves. When a report exceeds the limit, some rows aren't shown and a warning is displayed on the report.
To view the lens data details for a report table:
- Open the report that contains the table you want to view the lens data details for.
- In the report table toolbar, click .
The Lens Data Details window displays the following information:
- The total number of rows available in Analytics across all lenses.
- The maximum number of rows retrieved from Analytics, set by the Query Row Limit custom setting field.
- The total number of rows retrieved from Analytics.
- The total number of rows displayed in the report.
If your report uses more than one lens, you can also view a breakdown per lens. The Lens Data Details table details the row counts for each lens in your report.
Troubleshooting Missing Data and Unresponsive Reports
If your report doesn't include all the relevant data because of the query limit, you can try increasing the query limit. For more information, see Report Builder Settings Fields or contact your administrator. However, increasing the query limit can impact performance. If the report contains a very large amount of data, your browser might not be able to display it. This also depends on your device's processing capabilities, but it can result in the browser becoming unresponsive.
The primary cause of this issue is the raw data retrieved from Analytics. However, soft dates can make a report much larger than it looks, because they expand the data into more rows behind the scenes. As a result, a report that appears small can be very large underneath.
There isn't a single way of fixing or mitigating this problem that works universally. The solution depends on your report and requirements. You can try the following:
- Add more filters to the lens to retrieve less data. For more information, see the Salesforce Help.
- Add more filters to the report. For more information, see Configuring Filters in xRB Reports.
- Use drill-down levels so that the top level is a summary and the detail loads only when you need it. For more information, see Configuring Drilling in Tables.
- Reduce the date breakdown by grouping the data into higher-level periods. For more information, see Configuring Dynamic Soft Dates.
- Remove any columns that you don't need. For more information, see Configuring Dimension Columns and Configuring Measure Columns.
- Lower the query row limit. For more information, see Report Builder Settings Fields.