Participant Data Variable

Owned by Stephanie Brown (Unlicensed)
Last updated: Jan 14, 2020

You have the ability to set up a custom variable that looks at your study's data sources and its relevant data so that you can aggregate and perform calculations with that data.

This functionality will also be replace the functionality of the averager and summarizer

This functionality includes:

  • Ability to set up a new variable type on the Variables creation page 'Participant Data' 
    • The first field lets the user choose which data is used with the following options:
      • Min: The lowest value data point we received
      • Max: The highest value data point we received
      • First: The earliest data point we received
      • Most Recent: The most recent data point we received
      • Count: number of values included
      • Total: sum of included values
      • average: mean of included values
  • This will be followed by a data source selection field
    • Ability to choose from a list of data sources configured on the data sources admin page
    • Ability to choose multiple data sources

      • Variables can now look at multiple sources in order to give you more flexibility in updating participant data as needed. An example of this would be if you needed to make a second version of a survey after your intervention has launched. You could make the single variable look at both the answers from version 1 and version 2 of the survey in order to make sure all participants are assigned the proper variable in logic.

    • Ability to choose field selection, i.e. steps or distance
  • Once a field has been selected you can choose one of the following selection periods
    • previous _____ days
    • previous _____ days through previous ______ days
    • day ____ through day _____ (relative to start of study)
    • to date in study
  • Exclusion criteria section with the following fields
    • exclude values under _____
    • exclude values over   _____



The participant data variable can be used for all participant data events like enrollment run-in data events, weekly averages, data summaries. 

How do I set up a participant data variable? 

  1. Navigate to Manage Study> Variables
  2. Click the blue "New Variable" button in the top left corner
  3. You will see this form appear:
      1. Name and describe your variable
      2. Choose which arm this variable applies to
      3. Choose which type of variable you would like to create 
  4. Variable types include: 
      1. You will choose the Participant Data type
  5. Choose the data source
  6. Choose the data field
  7. Choose the data selection
      1. Here you can choose data selection criteria like the average, highest, lowest, most recent data points to be assigned to the variable. 
  8. Complete the filters
      1. You can choose:
        1. A date range
        2. Data from a certain event 
        3. Exclude certain values 
      2. Note: If you choose "all arms" for this variable, you can only choose enrollment steps for the "only include data attached to an event" filter above 
  9. Click SAVE!Â