Looker Studio Summary Row Errors When Using Filters

Looker Studio Summary Row Errors When Using Filters

Issue

When a Looker 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 because Looker Studio doesn't communicate to PMA whether the results should be filtered for the summary row. This leads to a mismatch between the filtered data and the unfiltered summary row.

Best Practices

To ensure accurate reporting, you must choose between two options when using Looker Studio:
  1. Use summary rows without applying filters
  2. Use filters without using the data reported in the summary rows


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

      • Related Articles

      • 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 Looker Studio. This bug only affects Unique fields. Cause This is an issue with Looker Studio and Google Sheets that ...

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

      • Incorrect Inventory Numbers from Amazon Seller

        This article will assist with the following problem: Inventory numbers in an Amazon report are bloated or incorrect. Cause The most common cause of this problem is a missing marketplace dimension or filter. Even if you configure your account to ...

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

      • All Fields Are Dimensions in Looker Studio Configuration Screen

        This article will address the following issue: Only dimensions appear in Looker Studio's configuration screen. All fields are green though metrics previously appeared in blue. Cause This is not an error. It was a part of Looker Studio's data modeling ...