To accomplish this, we can use an aggregate. When building a report, we can click the three dots next to any of the columns we have added to expand a list of options. One of the fields we will see when this is expanded is Aggregate.  Next to Aggregate will be a drop down menu where we can select what type of aggregate we would like to apply to the column. One of the aggregate options is Count, which we can utilize to show us the number of transactions each donor has within our query. 

For this example, we will build a report to pull in all donations to the General Fund in 2012, showing both the total amount each donor gave to the Fund as well as the number of transactions they had to that Fund.

A. First we query on all donations to the General Fund in 2012:
  1. Click Queries
  2. Click Manage Queries
  3. Select a category that you want to store this query in
  4. Click New Query under Tasks
  5. Name the query
  6. Set the Starting Query to Base/All Constituents
  7. Under Results, set the Data Return Type to Journal Entries
  8. Under Criteria Options mark Match each criteria
  9. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Journal Entry Date
  10. Fill in 1/1/2012-12/31/2012
  11. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Individual Transaction Received 
  12. Fill in Greater Than or Equal To .01
  13. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Funds
  14. Select General Fund
  15. Click Save and Preview
 
B. Now for the report:
  1. Click Reports
  2. Click Manage Reports
  3. Click a category that you want to store this report in (ex: system)
  4. Click New Report under the Tasks menu
  5. Name the report
  6. Under Group Results, select to Group Report By Accounts and Collapse Groups
  7. Under Browse Fields, select Commonly Used Fields in the drop down menu and click on Name, Date, and Received
  8. Click the three dots next to the Date field and select Count as your Aggregate
  9. Highlight the word Date and rename this field # of Transactions 
  10. Click Save and Run under the Task Menu
  11. Under Query select your category in the top box and your query in the bottom box
  12. Choose a Delivery Option at the bottom of the page and then click Submit
As you can see, we used the Date field to select the Count aggregate, because Date is a field that is required on each donation you put into eTapestry. When you add the Date field to your report and set the aggregate drop down menu to Count for this field, every transaction a donor has with a date (which will be every transaction since it's a required field) will be counted as 1 (because each transaction has 1 Date entered).

This report will show you the name of each donor, the number of transactions they gave to the General Fund last year (the Date field with aggregate) and then the total Received that each donor gave to the Fund.