topic Re: Likert data discrepancy in export in ArcGIS Survey123 Questions

Likert data discrepancy in export

Anonymous User — Tue, 21 Aug 2018 23:21:26 GMT

I created my survey in the Survey123 web app. When I export my data from the data tab into Excel I am seeing that the data changes for one of my questions and does not reflect the respondents answer.

The question type is Likert with a scale of 1-10 as the options to choose. In my Data tab online i can see when people have chosen 10. When I download this data as an xls this answer is being displayed as choice9 and not choice10 to reflect what I can see in the online response.

Is this an issue with how the likert question has been configured in the survey?

Re: Likert data discrepancy in export

JamesTedrick — Tue, 21 Aug 2018 23:24:58 GMT

Hi Louise,

Single-choice questions like likert use a coded value lookup that separates the value stored from the value shown. In this case, the values stored are most likely choice0, choice1, choice2, etc. - if you have a 1-10 scale, the corresponding choice would be choice9 (0-9 vs 1-10). This is configurable when publishing a survey on the website via the 'Manage Schema' link - that enables customization of field names and choice values.

Re: Likert data discrepancy in export

Anonymous User — Tue, 21 Aug 2018 23:46:44 GMT

Thanks James that makes sense and I'll definitely modify the schema for future surveys to adjust that field value to match the answer when using 1-10 scale.

Re: Likert data discrepancy in export

ShariForbes — Mon, 05 Apr 2021 20:16:41 GMT

I just had the same thing happen to me! I will pay attention to that closer for the next survey.