Metric filter(s) won't work with summary row in Looker Studio with Google Ads Connector

Looker Q&A Looker Studio
1

When creating a table in Looker Studio, I have added a filter to Exclude Conversions < 1 and when I try to display the summary row, I get an error that says “Metric filters can’t be used with summary rows or analytical functions.” Is there any way to work around this? We have used this filter with the summary row displayed in the past and it is common in our reports - our clients love having the summary row and most really dislike seeing rows that don’t have useful stats, like conversions/clicks/etc less than 1.

Thank you!

1 Like
2

Thanks for sharing your use case! I can’t think of any way to have both the metric filters and the summary row. I think this is a good feature request!