0

I have a survey in REDCap. Some of the participants were completed the survey without attending an event. When I export the data I am required to get the data without those participants every time automatically. Could anyone please help me to do it? Thanks in advance. I am not supposed to delete their response on REDCap.

I am only seeing data export option which gives survey data of all participants. I could not do more because it's real time data and I am afraid I might end up deleting it unknowingly.

wibeasley
  • 5,000
  • 3
  • 34
  • 62
Sindhuja
  • 1
  • 1

1 Answers1

1

Go into Reports, Exports and Stats, and create a new report. Select the variables you want the report to contain, and write a report filter to include only those records you want. In this case, you might include a filter such as where a particular form is completed, and only those records for which that form is completed will appear in the report.

It isn't clear from your question what 'event' refers to. If it is a REDCap longitudinal event, then you might want to rely on, say, the completion of the last form in that event. If the event is [event_1_arm_1] and the last instrument on that event is [final_survey], then you could rely on the value of [event_1_arm_1][final_survey_complete]. If they have completed the 'final survey', then this value will be 2. If they haven't, then it will be not 2.

Thus, including a report filter such as [event_1_arm_1][final_survey_complete] = 2 will exclude from your report all records that have not completed event 1.

One you have a report that returns the correct records and your desired columns, you can export it in exactly the same way as you would export the 'all data' report.

Jangari
  • 690
  • 4
  • 12