Looker Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date

Looker 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 Looker 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.
  1. 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.
  2. 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


    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • 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 ...
      • Looker Studio Blending Super Guide

        The following article provides useful tips for how to blend data in Looker Studio.   What You Can Blend A list of what you can blend in Looker Studio: Two data sources that share the exact same dimension.  The keywords here are "dimension" and ...
      • 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. ...
      • Export a Looker Studio Report to PDF

        This article will show you how to export your Looker Studio report to a downloadable PDF format. To export your Looker Studio report to a PDF, open your report. Click the down arrow on the Share button. Then click Download report. Select the pages ...
      • What to Do When a Report Is Loading Slowly

        We understand how frustrating it is when you take time to build a report and it is loading very slowly or timing out. This article will help you with some troubleshooting steps you can use to get your reports loading quickly again. Looker Studio Use ...