Giving Snapshot by Quarters
===========================
This script can be added to the blue Toolbar and will be available on Search Builder results,
an Organization, or a Tag. If you run it from Special Content, the report will look at the last
Search Builder results and runs the script for those individuals.

It displays giving totals by quarters for a three-year period for the designated fund. By default,
the three-year period ends with the current year, but you can change the script so that the period
ends with the year of your choice.

.. important::
    The report shows giving for donor only. It does not combine family or couple giving. A use
    case for the report might be to show donor totals for an age range.

The recommended name is ``GivingSnapshotByQuarters``

Use the :ref:`code below <GivingSnapshotByQuarters>` to create the SQL Script.

See :doc:`../CreateSqlScript`.

The top declaration statements are where you can set/change the parameters for the report.
Currently, the report is set for Fund ID = 1 and for the three-year report period to end with
the current year. To change the Fund ID, enter the desired ID in line 4.

To change the report's three-year period to end with a year other than the current year, add two
dashes ``--`` to the beginning of line 7 to comment it out and remove the two dashes at the beginning
of line 9. Then enter the ending year within the single quote marks after the ``=`` sign. If the ending
year is changed, the column headers for the yearly totals should also be changed. This can be on lines
173, 178, and 183 of the script.

.. _GivingSnapshotByQuarters:

SQL Code for the Report
-----------------------

.. literalinclude:: Files/GivingSnapshotByQuarters.sql
    :linenos:

|
|

+--------------------+------------------+
| **Latest Update**  | **07/06/2020**   |
+--------------------+------------------+

Added this article.