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:
- Use summary rows without applying filters
- Use filters without using the data reported in the summary rows