User Support Forum

I've been asked to generate a report that lists members who have missed the past two Sundays, but have attended at least three times in the last eight weeks. Any suggestions on how to go about doing this as a Custom Report in the Membership module?

Thanks for your help...and Merry Christmas!

This is a very tall order and difficult to achieve. It has been asked of the Custom Reports department here, but I don't think it was possible or affordable.

Due to the original query, selecting only those who were absent over the last two weeks, you then don't have access to any of the other weeks of attendance status. You would need to look at all attendance history, then use a bunch of variables in the report to check the count of each individual's status attendance. It gets messy when you start thinking about the logic that would be necessary.

I was afraid you'd say that! Thanks anyway!
Dianne