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.
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>