Professions of Faith YTD
Using a Dynamic Data block under reporting you can create a year-to-date count of people.
Remember that your person attribute for this will most likely have a different key, you can find that 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] = 'DateProfFaith'
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">Profession of Faith YTD</h4>
</div>
<div class="panel-body">
<p>{% for row in rows %} {{ row.Count }} {% endfor %}</p>
</div>
</div>
</div>