select Opportunity__r.Country_of_Ownership__c, CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c)Vmonth, COUNT_DISTINCT(Opportunity__r.Id) Volume from Transaction_Allocation__c where ( Transaction_Allocation__c.Stage__c IN ('Posted','Refunded','Failed','Refund','Reversal') AND (Transaction_Allocation__c.Close_Date__c > 2022-03-31 AND Transaction_Allocation__c.Close_Date__c < NEXT_N_DAYS:1) AND Opportunity__r.RecordTypeId IN ('012w00000006jGy','0122X000000ie1A') AND Opportunity__r.Date_Recurring_Donation_Established__c > 2022-03-31) Group by Opportunity__r.Country_of_Ownership__c , CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter