select Donor_Contact__r.Country_of_Ownership__c, COUNT_DISTINCT(Donor_Contact__r.Id) The_Count from Opportunity where Donor_Contact__r.npo02__LastCloseDate__c< LAST_n_MONTHS:24 AND RecordTypeId IN ('0122X000000ie1A','012w00000006jGy','012w00000006jGe','012w00000006jGo','012w0000000MQol','012w0000000MQuZ','012w0000000hbgn') and Amount>0 AND StageName IN ('Posted','Refunded','Failed','Refund','Reversal') AND Donor_Contact__r.Donor_Status__c IN ('Active','Lapsed','Laspsing') AND Donor_Contact__r.CIWF_Digital_Test_Account__c = FALSE Group by Donor_Contact__r.Country_of_Ownership__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