We are grouping our bills based on a custom attribute. For example - affiliate.
So, we have set affiliateId as a custom attribute in the Transaction recording policy. This lets us apply different rate plans for different affiliates.
And we get the volume/ charge aggregate at affiliate level, as below
dev_name, dev_id, affiliate_id,volume, charge
ABC,123,aff_1,10,5
ABC,123,aff_2,20,10
My question is that if we have multiple custom attributes, will the report be aggregate at a unique combination level? i.e if I have another custom attribute as country and if aff_1 makes call from both US and UK, I want the report to look like -
dev_name, dev_id, affiliate_id, country,volume, charge
ABC,123,aff_1,US, 6, 3
ABC,123,aff_1,UK, 4, 2
ABC,123,aff_2,US,20,10
A yes or no will be fine 🙂
Aggregates should work as you describe if and only if all data in the report has the same custom fields recorded in the same order.
User | Count |
---|---|
7 | |
2 | |
2 | |
1 | |
1 |