Help creating multi-value reports for staged return to meetings
Posted: Sat Jun 06, 2020 7:54 am
Hello all, newly-called ward clerk here.
I've been asked to help create a model for the 'return to church' plan that we may put in place in July.
My idea that I'd like to test is to create 4 different reports:
- Household report with anyone who has children 11 years old and younger
- Household report with anyone between the ages of 12 and 18
- Household report of anyone without children or youth who are under age 55 or younger
- Household report with members who are over 56 or older
The last one is easy, figured that one out with the web interface through Reports. The other ones... not sure how to best do those. My goal is to create a way to get total numbers for those 4 groups, thereby splitting attendees into the 'under 100 potential attendee' range to abide by Utah's meeting standards. There will be overlap, but I was planning to export the data to Excel to do some processing separately there...
Which brings up another question, what is the most-efficient way to export web reports to Excel? I see the Save and Edit Report options in the upper right of the web interface...
Anyone else out there trying to build attendance models to split wards into similar groups? My thought with this approach is you basically create a primary-focused mini-ward, a youth-focused mini-ward and then empty nesters under 55 ward. Those over 55 would not be encouraged to attend until we've got better public health data.
I've been asked to help create a model for the 'return to church' plan that we may put in place in July.
My idea that I'd like to test is to create 4 different reports:
- Household report with anyone who has children 11 years old and younger
- Household report with anyone between the ages of 12 and 18
- Household report of anyone without children or youth who are under age 55 or younger
- Household report with members who are over 56 or older
The last one is easy, figured that one out with the web interface through Reports. The other ones... not sure how to best do those. My goal is to create a way to get total numbers for those 4 groups, thereby splitting attendees into the 'under 100 potential attendee' range to abide by Utah's meeting standards. There will be overlap, but I was planning to export the data to Excel to do some processing separately there...
Which brings up another question, what is the most-efficient way to export web reports to Excel? I see the Save and Edit Report options in the upper right of the web interface...
Anyone else out there trying to build attendance models to split wards into similar groups? My thought with this approach is you basically create a primary-focused mini-ward, a youth-focused mini-ward and then empty nesters under 55 ward. Those over 55 would not be encouraged to attend until we've got better public health data.