Baptisms YTD

Shows number of people baptized that year to date. Use the Dynamic Data block under reporting to create this widget.

Remember that your person attribute key could be different than ours so be sure to look that up under person attributes.

Screen Shot 2017-09-02 at 12.54.54 PM.png

Screen Shot 2017-09-02 at 12.55.53 PM.png

Screen Shot 2017-09-02 at 12.55.58 PM.png

Query from above:

SELECT COUNT(*) AS [Count]
FROM Person P
INNER JOIN AttributeValue AV ON AV.EntityId = P.Id
INNER JOIN Attribute A ON A.Id = AV.AttributeId AND A.[Key] = 'BaptismDate'
WHERE DATEPART(year, AV.ValueAsDateTime) = '2017'


Formatted Output from above:

<div class="col-md-12">
<div class="panel panel-block">
<div class="panel-heading">
<h4 class="panel-title">Baptisms YTD</h4>
</div>
<ul class="list-group list-group-panel">
<div class="panel-body">
<p>{% for row in rows %} {{ row.Count }} {% endfor %}</p>
</div>
</ul>
</div>
</div>


HELP