Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?