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.