


I'm looking for some help in getting counts for records in Campaign. I have an external transactions database that I'm querying as the target and filtering dimension. Within the table is a field (MemberID) that can be duplicated across multiple transactions, so after I have the transactions returned that i'm looking for, I want to have a count of the number of times the Member ID appears. Example:
TransactionID (Key) | MemberID |
1 | 11111 |
2 | 22222 |
3 | 11111 |
4 | 22222 |
5 | 33333 |
I want to get a count of the number of times the MemberID appears, but I'm having issues because the MemberID is not a key. I have no problem doing counts other times with counts related to the table keys, but I'm lost on this one. I'm looking for results like:
Member ID | Count of MemberID |
11111 | 2 |
22222 | 2 |
33333 | 1 |
Any help would be greatly appreciated.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @whalen1618 ,
click on Advanced Parameters and select option Disable automatic adding of primary keys of the targeting dimension and that will work for you. Needed only when you do aggregation which does not include primary key.
Regards,
MIlan
Views
Replies
Total Likes
Hi @whalen1618 ,
click on Advanced Parameters and select option Disable automatic adding of primary keys of the targeting dimension and that will work for you. Needed only when you do aggregation which does not include primary key.
Regards,
MIlan
Views
Replies
Total Likes