Dear all,

I have a project which sends surveys to participants based on certain events.

I would like to workout the response rate per participant for the past 2 weeks and list their pid if the rate is less than 50%.

My variables are pid (participant id), survey_sent (the name of the survey that was sent), date_sent (date the survey was sent) and responded (yes no field that indicates whether a survey was responded to).

I hope this covers all info required for help.

Thanks!