I am trying to count to number of subscribers have made a transaction. I am using the code below:
SELECT M.Id SubsriberKey ,COUNT (Transaction_ID__c) OVER (PARTITION BY M.Id) AS NumberOFTransactions FROM MasterSubscriberDE M LEFT JOIN SalesDE S ON M.Id = S.Id GROUP BY M.Id, S.Id, Transaction_ID__c
My query is returning zero for all the subscribers, even though there are transactions in the Sales table (i.e Transaction_ID_c is not empty).
I will appreciate any help on this.