How do I Aggr orders by unique customers

[jerry_ile]

Hi,

I am attempting to create a table that gives a topline grouping of customers by the amount of orders they have created, I can't do this in the load script as need to be able to change time periods 

It should look like this 

Frequency (Orders)	Count(distinct [Order ID])	count(distinct [Customer ID])
1	43063	43063
2	16116	8058
3	8091	2697
4	4272	1068
5	2600	520
>5	8393	731

I tried 

aggr(if(count(distinct [Order ID])<=5, Text(count(distinct [Order ID])),'>5'), [Customer ID])

aggr(if(count(distinct [Order ID])<=5, Text(count(distinct [Order ID])),'>5'), [Customer ID])	Count(distinct [Order ID])	count(distinct [Customer ID])
	82,535	56,137

but it shows as a blank, if I add customer ID as a dimension I can see that the aggr is correctly grouping the customers, but just can't get it to show in the table ?

[Lauri]

It'd be worth upgrading to June 2019 just to see. If no luck there, go to support:
https://qliksupport.force.com/qs_home_page