Attendance Statistics by week (and age group) for any given 'group'

[s4069b]

Does anyone else have this 'need'?

I want to be able to generate a report for a given Group (or Congregation) that'll show how many people were in attendance each week - by age-group. Maybe even with a total for the month.

Something like this:

Group or Congregation Date Date Date Date
Adults 99 101 98 120
Children 25 30 20 40 Total 124 131 118 160

Even better would be to include two more columns: 'total for the month' and 'average for the month'.

At the moment the closest I can come is if I view attendance statistics and specify ONE single day. And then look at the relevant table that gets generated (there'll be one for each group or congregation on that day).

Then I need to repeat the same for the next single day. yes... it's a very slow work around.

[tim-pearce]

You could do that using document merge of a spreadsheet. I pretty much do this already, except for the age breakdown - that would make it a bit trickier.

What I generate is monthly attendance for members with totals at the end. If you only wanted the numbers you would have to hide the rest of it.

[tbar0970]

It sounds like some extra summary rows at the end of the "Attendance > Display" page would fill this need?

[tbar0970]

Ie at the moment, for each dated column, we have "Total present" row at the bottom. We could add rows for "Total present - Adult", "Total Present -Child" etc. And we could add an "average" column at the end.

(I'm not sure a monthly "total" would make much sense, since it woudn't be clear whether "100" means the same 25 people x 4 weeks or 25 different people each week. Is this some denominational requirement?)

[s4069b]

That last suggestion sounds good. Trick may be how best to satisfy different 'age' or 'categories' needs? Perhaps a few drop-downs at the top of the screen when you select the attendance details - say three or four that allow the user to select a few age-groups? (or leave it blank if they don't care)

A related use could be, for example, the Kids Ministry coordinator wanting to see how many children have been at services, or how many year 2 children to be precise.

Or the Youth Group leaders might want to work out how many year 6 kids to expect to see moving to year 7... being able to tally attendance from the 9:30am service separating out the number of year 6 kids would be handy (assuming that you've already setup the year 6 age-group etc etc).