Giving to Budget Comparison Widget
==================================
The Giving to Budget Comparison widget displays a circular gauge that gives a visual indication of how
nearly your church is on track for the budget of a specified fund. Below the gauge is displayed:

-   the total amount given to the fund Year to Date
-   the budget amount Year to Date
-   how much over or under budget has been given
-   the weekly average given Year to Date
-   the amount given in the last seven days

The widget utilizes an HTML file, SQL script and Python script as shown below. Since the giving data
is the same for all users, Caching should be set to **all users**.

To customize the widget, you will need to make a few changes in the Python script.

-   On line 2 of the Python script, change the fund ID if necessary to the desired
-   On line 4, change the annual budget amount for the specified fund
-   On line 6, change the start date to the beginning of the current calendar year or, if different, the beginning
    of your fiscal year

Video
-----
Below is a short video demonstrating some of the features of this widget.

.. raw:: html

    <iframe width="560" height="275" src="https://www.youtube.com/embed/T4F0A4pg160?rel=0"
    frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

|

HTML Code
---------
Below is the HTML code for the Giving to Budget Comparison widget. As supplied by TouchPoint, the file name is
**WidgetGivingToBudgetComparisonHTML**.

.. literalinclude:: Files/WidgetGivingToBudgetComparison.html
    :linenos:

SQL Script
----------
Below is the SQL script for the Giving to Budget Comparison widget. As supplied by TouchPoint, the file name is
**WidgetGivingToBudgetComparisonSQL**.

.. literalinclude:: Files/WidgetGivingToBudgetComparison.sql
    :linenos:

Python Script
-------------
Below is the Python script for the Giving to Budget Comparison widget. As supplied by TouchPoint, the file name is
**WidgetGivingToBudgetComparisonPython**.

.. literalinclude:: Files/WidgetGivingToBudgetComparison.py
    :linenos:

|
|

+--------------------+------------------+
| **Latest Update**  | **08/12/2020**   |
+--------------------+------------------+

Added video.