Error in agregation using GA4 to looker studio default connector + CASE filter

[zoercalm]

Hello there.

I have really hard time migrating dashboards from GA3-looker studio to GA4 to looker studio.

The thing is we use CASE function for filters and after applying this filter the data shows NULL. Moreover, some metrics like average session duration start to show not AVG but SUM

Here is a fast report with Google Merch Shop connected where you can see this issue.

 1 data without filtering:

2 data with filtering:

I have shared the report for anyone who wants to hands on

I would be super grateful if anyone can share a solution on how to get the correct result or any useful information))

[Rick_E · Accepted solution]

I apologize for the inconvenience here. Unfortunately, that is a limitation with the Google Analytics connector:

When a table is filtered by a calculated field, the Google Analytics connector doesn't support the display of totals in the table's Summary row, if present. When a table is the target of a filter of any type, and the filter condition is based on a calculated field, a custom group, or a bin, the grand total displays null.

For alternative solutions, you might try using the Google Analytics exploration tool or exporting your data to BigQuery.