Add the number of active volunteers to the summary endpoint. A volunteer counts as active if they completed a submission/made a transcription in the last 2 weeks (or another short time frame). This would give us the opportunity to see how many volunteers are actually still transcribing and whether we are gaining or losing active volunteers.
This can be archived by a query like the following (not tested):
So we filter the submissions by those that have been completed within the last two weeks, then group it by the volunteers who completed it (so that we have a volunteer count, not a submission count) and then count how many we have.
Add the number of active volunteers to the
summary
endpoint. A volunteer counts as active if they completed a submission/made a transcription in the last 2 weeks (or another short time frame). This would give us the opportunity to see how many volunteers are actually still transcribing and whether we are gaining or losing active volunteers.This can be archived by a query like the following (not tested):
So we filter the submissions by those that have been completed within the last two weeks, then group it by the volunteers who completed it (so that we have a volunteer count, not a submission count) and then count how many we have.