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 made by donors in each state in 2018, showing both the total amount donors gave per state as well as the number of transactions per state.

A. First we query on all donations in the database for 2018:
  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/2018 - 12/31/2018
  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. 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 Browse Fields, select Commonly Used Fields in the drop down menu and click on State/Province, Date and Received
  7. Click the three dots next to the Date field and select Count as your Aggregate
  8. Highlight the word Date and rename this field # of Transactions 
  9. Under Group Results, select to Group Report by State/Province and Collapse Groups
  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 State, the number of transactions given to that State in 2018 (the Date field with aggregate) and then the total Received that donors gave.