AnsweredAssumed Answered

Tracking attendance

Question asked by DaleLyles on Jul 27, 2018
Latest reply on Jul 27, 2018 by mikebeargie

This should have been easy, but it's got me stymied. I need to create a sign-in system that will allow me to track participant attendance at the 1 month, 3 month, and 6 month points, and I'm stymied.

 

At the moment, I have the participant signing in with first name, last name, and the DB automatically generates the date. I can count the number of weeks since the participant first showed up, but I also need to count the number of times in that period that they've signed in.

 

So if I have the following entries:

 

First Name

Last Name

CreationTimestamp

Joby

Johnson

04/26/2018

Joby

Johnson

04/27/2018

Jim

Kirk

06/26/2018

Jim

Kirk

06/27/2018

Jim

Kirk

06/28/2018

Dale

Lyles

07/26/2018

 

... how can I calculate that Jim Kirk has signed in 3 times in the last month?

Outcomes