Data Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date
This page will assist you with the following issue:
When reporting individual values by date in Data Studio, the sum of these individual values over a date range may be less than the grand total of the values over the same date range.
For example, this Google Analytics 4 (GA4) report of Total Users by Date over June 1 - 2, 2024 shows values of 331 and 290, summing to 621 Total Users.
However, the grand total shown is only 609.
Similarly, using a date control that spans June 1 - 2, 2024 while reporting Total Users without any dimensions will produce a value of 609.
Cause
Both the daily values and the grand total are correct. The grand total is a unique count over the date range.
- In this example, because the summed rows showed 621 total users and the grand total showed only 609 over the date range, this is a difference of 12 users. This means 12 users were present on both June 1 and June 2, 2024.
- A sum of total users by day (equalling 621) would result in these users being counted twice, once for each day, while the grand total is the de-duplicated value (609).
The following is a partial list of fields whose daily values will not sum up to the grand total over a multi-day range. The sum of the daily row values for these fields will exceed the grand total:
| Data source | Affected fields |
Facebook Ads | Reach, Frequency |
Google Analytics 4 | All fields containing "User" (Active Users, Active1day Users, Active7day Users, Active28day Users, Total Users) except for New Users |
| LinkedIn Ads | Reach, Average Frequency |
Pinterest Ads | Reach, Frequency |
Snapchat Ads | Earned Reach, Paid Reach, Total Reach, Frequency |
TikTok Ads | Reach |
Related Articles
Create Looker Studio Reports with Power My Analytics
Looker Studio is one of the most popular destinations for visualizing your Power My Analytics data. This guide brings together everything you need to get started with Looker Studio, build effective reports using PMA connectors, and troubleshoot ...X Ads Grand Total is Greater than the Sum of Values when Reporting by Country
When using our X Ads connector to report data using geo dimensions (such as Country), you may notice that the grand total (summary row) for a metric shows a higher value than the sum of the report’s data values. This article will explain why this ...Looker Studio Demo Template Guide
When connecting to Looker Studio, there are a few best practices to keep in mind. From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Demo Power My ...LinkedIn Ads and LinkedIn Companies Grand Total Displayed Does Not Match the Sum of the Values in Some Charts
This article will assist with the following problem: Grand Total lines in LinkedIn Ads and LinkedIn Companies reports do not match the sums of the values. In LinkedIn reports in Looker Studio, some totals displayed do not appear to be accurate. In ...How to Connect a Google Sheets Report to Looker Studio
In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...