Survey questions not showing in Excel Analyser Value section

User Support Data Management
,
42

OK, so I have done the following and it should work:

  • Downloaded your questionnaire (xlsform) from your user account.
  • Downloaded your dataset (XLS legacy format) from your user account.
  • Downloaded the Empty Excel Analyzer from this site.
  • Copied the survey tab of the questionnaire to the Empty Excel Analyzer.
  • Copied the choices tab of the questionnaire to the Empty Excel Analyzer.
  • Copied the dataset downloaded as XLS (legacy) to the Empty Excel Analyzer.
    • The main dataset is marked as data_main while the roster dataset is marked as data_roster.
    • After copying the dataset, I changed the header name of the dataset that matches with the xlsform.
    • Before:
      image
      image1349×57 3.61 KB
    • After:
      image
      image1086×49 3.27 KB
  • Manually typed the data_main or data_roster in the Data as shown in the image below:
    image
  • Similarly, typed the survey in the Survey as shown in the image above.
  • Also typed the choices in the Choices as shown in the image above.
  • If you wish to analyze your data from the data_main you could type in manually else you could also type in data_roster to analyze the roster data.
  • You should now be able to analyze your data from this Excel Analyzer.

Note: At the moment, you only have 4 submissions in your survey project. But when you proceed with the survey you could copy and paste the submissions to the attached Excel Analyzer without chaining the header name of the Excel Analyzer.

Reference Excel Analyzer:

KoBoToolbox Excel Data Analyser 1.23.xlsx (1.3 MB)