--- title: "Consecutive Year of Giving & Sequential Value Groups" slug: "consecutive-years-of-giving-sequential-value-groups" updated: 2026-03-04T20:54:02Z published: 2026-03-04T20:54:02Z --- > ## Documentation Index > Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt > Use this file to discover all available pages before exploring further. # Consecutive Year of Giving & Sequential Value Groups [YouTube video player](https://www.youtube.com/embed/gziwTSl9qMc?si=tmB0nrXf3OFMPJen) A donor’s length of consecutive giving can be queried using the special system join of *Sequential Value Groups*. This join enables identifying a data point (such as a gift's year) that can then be used to count the number of times it appears consecutively (such as 2016, 2017, 2018, 2019, and 2020), as well as the minimum and maximum range of the consecutive span (such as 2016 and 2020). For example, an institution might want to query for donors who have given consecutively for at least 5 years, displaying the number of consecutive years given as well as the start and end date for the range. This type of query can be configured in two primary steps: 1. Add a subquery filter based on consecutive giving. 2. Add a subquery export that returns the details of the consecutive giving. The output of this type of query will resemble this example: [![Sequential_Value_Join_-_Output.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/sequential_value_join_-_output.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/sequential_value_join_-_output.png)


Adding the Subquery Filter

 To identify donors who have given consecutively for at least 5 years, you will need to establish the sequential data point to count. In this example, the data point to be counted is the gift year. 1. Create a new query using Person as the base. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/image-H1B32BI0.png) 2. In the **Filters** section of the query summary page, click the subquery icon. An **Edit Part** popup appears to configure a dependent subquery. 3. In the **Filters** section of the popup, click **Join**. An **Insert Query Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Join Button.png) 4. Locate and select the **Sequential Value Groups** join and click **Continue**. An **Edit Part** popup for the join appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Sequential Value Groups Part.png) 5. In the **Filters** section of the popup, click **Join**. An **Insert Query Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Additional Join.png) 6. In the **Person** section, locate and select the **Gifts** join, and click **Continue**. The **Gifts** join popup appears. 7. Click **Save**. The **Sequential Value Groups** join popup appears. 8. Click **Export**. An **Insert Query Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Export Button.png) 9. In the **Gifts** section, select **Date** and click **Continue**. The **Gifts Date** export appears on the **Edit Part** popup. 10. Edit the **Gifts Date** export and set desired **Format Type** and **Format Mask**values. In this example, **Format Type** is set to **Date** and **Format Mask** is set to “yyyy.” ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Edit Date.png) 11. Click **Save** to return to the original subquery filter configuration popup. Give the filter an appropriate name. This example uses “Gift Date Sequential Values” as the value for **Name**. 12. Click **Save**. The subquery filter appears in the **Filters** section of the **Edit Query** summary page. 13. In the **Exports** area of the summary page, click the subquery icon. An **Edit Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Export Subquery Icon(1).png) ## Adding the Subquery Export 1. In the **Exports** area of the summary page, click the subquery icon. An **Edit Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Export Subquery Icon(1).png) 2. Follow the same steps (2 through 11) used for the subquery filter process to configure the subquery export. 3. On the original subquery export popup, click **Export**. An **Insert Query Part** popup appears. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Subquery Export Export Button.png) 4. In the **Sequential Value Groups** section, select **Count**, **Min**, and **Max**, then click **Continue**. 5. To see all three data points, set the **Output** value to **Concatenate** and reorder the exports and add literal values (to provide context to the returned values) as desired. 6. Give the subquery an appropriate name and click **Save**. As configured in this example, the query now returns values for Person ID, First, Last, and the configured values for Consecutive Years Giving. ![](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/Results.png) The query can be further refined to limit results to a specific number of consecutive years within a specific range.