Data Studio Summary Row Errors When Using Filters

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 because Data 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 Data Studio:
  1. Use summary rows without applying filters
  2. Use filters without using the data reported in the summary rows

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

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

    • Data Studio Error Troubleshooting Guide

      Getting an error in Data Studio? Click on the wrench icon or "See details" link to find the error details. Common Errors Error: You must select a valid config when connecting to the data-source Error: This action is not supported while logged into ...

    • Reconnect a Source in Data Studio

      Many Data Studio errors can be fixed by simply reconnecting a data source. This article will show you how. 1. In Edit mode, click Resource and select Manage Added Data Sources. 2. Find the data source that is receiving the error and click Edit. 3. ...

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