Incorrect Summary Row Whenever Filter Is Applied

This article will address the following issue:

Data in the summary row for Unique fields is incorrect whenever a filter is applied in Data Studio.

This bug only affects Unique fields.

Cause

This is an issue with Data Studio and Google Sheets that has not yet been resolved by Google. 

• Related Articles

• Data Studio Summary Row Errors When Using Filters

  Issue When a Data Studio query includes both a filter and a summary row, the summary row displays incorrect data or no data. Instead of showing totals, it may report the first result from the data source for each column. Cause This error occurs ...

• 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, ...

• 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 ...

• How to Accurately Warehouse Reach and Frequency Data in BigQuery

  Reach and Frequency are powerful metrics, but they don't behave like other ad metrics inside a data warehouse. This article explains why summing them across rows can produce inflated numbers, and walks through the recommended approach for working ...