Google Data Studio Advanced Filter for column SUM aggregation

Question

In BigQuery I have a table customers with columns date, customer, orders_count. And in Data Studio I have a table with columns customer, orders_count_total and a Date Range Control. So if I choose a date range for example Last Week, in DS table column orders_count_total summarizes orders_count for each customer for the Last Week. And I add a Advanced Filter Control to filter all customers with orders_count_total > X. But this filter filters only orders_count per day, not per Week. So if some customer has orders_count_total = 70 for the last week, and i set in filter orders_count > 50, this customer does not appear in the table, because this customer doesn't have > 50 orders per day. Is it possible to apply Advanced Filter to SUM(orders_count), not for orders_count?

question from:https://stackoverflow.com/questions/65842592/google-data-studio-advanced-filter-for-column-sum-aggregation

Answer 1

Waitting for answers