I suggest you ...

Improve export of RELATIONAL data

When relational data are exported, the results are flattened in a way that makes data analysis unbearably complicated. Suppose a question asks the user to enter up to 5 foods they ate, and the following page pipes those responses into a question which asks the respondent to indicate if anyone in their group at the same food (yes, no, DK). Currently, the export will create one column for **for every food item ever entered in the survey**. This means that if I have 100 respondents and each of them enters a different food, I am going to end up with up to 500 columns for each food ever entered (assuming the values are unique). If I have another question that asks what day the food was consumed, there will be another 100+ columns in the export representing the response for each food item. Is it not possible to set up the export of relational data in such a way that there are only 5 column headers, i.e, FOOD1, FOOD2, FOOD3, FOOD4, FOOD5, with a value for each food type entered, and then another 5 columns labeled "Group Meal1" through "GroupMeal5" (or however the user specifies the field should be labeled) with a yes/no/DK response recorded in each cell? There should only be a single row per respondent. Ideally users should be able to specify the variable names for the rows/columns ahead of time, during the survey definition/editing stage, before defining the criteria for data export -- otherwise the user would have to redefine the row/column labels each time they are ready to export the data (not desirable!). The current export functionality is also messy with matrix-type questions that allow the user to combine free-text, radio, and checkbox types into a single question.

22 votes
Vote 0 votes Vote Vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service

    You'll receive a confirmation email with a link to create a password (optional).

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Atar BaerAtar Baer shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service

      You'll receive a confirmation email with a link to create a password (optional).

      Signed in as (Sign out)
      Submitting...

      Knowledge Base and Helpdesk