KPI + aggregated filter


I have a table with customers and amounts (USD), I’d like to show a KPI with number of customers which have paid 2000 USD or more during the last year. All the calculated fields that I tried give errors related with nesting formulas are not allowed.

Can you try this?

Total amount per customer = sumOver({amount}, [{customer id}], PRE_AGG)

Then add customer id (Count distinct) to a KPI visual and filter by Total amount per customer >= 2000 and last year.


Great, it works perfectly. Thanks

1 Like

Thanks for letting us know @KLIKIN!