Attendance Year over Year Widget ================================ The Attendance Year over Year widget displays a line graph showing historical attendance for selected divisions. Attendance for for the current and previous years are shown via color-coded lines with a color legend at the top of the graph. The widget utilizes an HTML file, SQL script and Python script as shown below. Since the attendance 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. - Replace lines 6 - 8 with the names and IDs of the division(s) for which to display attendance. The sample shows three divisions, but you can use more or fewer. Enter one line per division in the format ``['division name', id],``. The names are informational within the script and do not display on the graph. - Modify line 12 set **startyear** with the first year to include. Only three years can be displayed, so you can select the past year (to compare only last year and this year) or the year before that (to compare the previous two years and the current year). Video ----- Below is a short video demonstrating some of the features of this widget. .. raw:: html | HTML Code --------- Below is the HTML code for the Attendance Year over Year widget. As supplied by TouchPoint, the file name is **WidgetAttendanceYearOverYearHTML**. .. literalinclude:: Files/WidgetAttendanceYearOverYear.html :linenos: SQL Script ---------- Below is the SQL script for the Attendance Year over Year widget. As supplied by TouchPoint, the file name is **WidgetAttendanceYearOverYearSQL**. .. literalinclude:: Files/WidgetAttendanceYearOverYear.sql :linenos: Python Script ------------- Below is the Python script for the Attendance Year over Year widget. As supplied by TouchPoint, the file name is **WidgetAttendanceYearOverYearPython**. .. literalinclude:: Files/WidgetAttendanceYearOverYear.py :linenos: | | +--------------------+------------------+ | **Latest Update** | **08/12/2020** | +--------------------+------------------+ Added video.