In the choice sheet the ‘name’ is pace while in the survey sheet the ‘name’ is covid, the question type is select_one. Could someone explain please what these two values refer to?

User Support Form Building
1

Hi, I am using Power BI to pull in data from a Kobo survey that a colleague built. I need to connect the submission values to the choices and to the question text. So that users can select a question (seeing the whole question rather than just the id) and see the number of respondents for each choice (where the choice is written out rather than a number).

I am confused about how the questions and choices are connected.

image

In the choice sheet the ‘name’ is pace.
In the survey sheet the ‘name’ is covid, the type is select_one pace

Could someone explain please what these two values refer to?

3

Hi @naledi_h, the “pace” in “select_one pace” refers to “pace” in the list_name column of the choices sheet. The name “covid” is the unique variable/XML name that the response to that question is assigned to.

You can refer to the xlsform documentation for more info.

1 Like
4

Thank you @Josh, that’s the piece of documentation I was looking for

2 Likes