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 ?
