KPI + aggregated filter

Question & Answer
,
1

Hi,

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.

2

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.

2 Likes
3

Great, it works perfectly. Thanks

1 Like
4

Thanks for letting us know @KLIKIN!