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 Data Studio Reports with Power My Analytics

      Data 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 Data Studio, build effective reports using PMA connectors, and troubleshoot common ...

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

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

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

    • Troubleshooting Calculated Fields in Data Studio

      This article will assist with calculated fields that are displaying incorrect results. Check Parentheses The most common cause of calculated field errors is missing parentheses. Type SUM(fieldname) around each field to obtain correct results. Prefer ...