Preview:
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
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