In this article
Vpath references variables in a Studio report using dataset, table/level, variable, and fieldID syntax. Use $other to specify Other, specify category codes.
In a Studio report, you frequently need to reference specific variables, such as to determine which results to display in a widget. You reference variables using a "variable path," referred to as the Vpath. The syntax for the Vpath is as follows:
dataset.table:variable[.fieldId]
where
A dataset is a Hub dataset that you reference using its "public name." It could be a survey, a custom data table, or a contact database.
A table or level in the dataset is referenced by its name or level in the survey. For surveys, you can reference respondent, response, or each of the loops. For contact databases, you can reference response and the surveyactivity loop. For panels, you can reference response and the surveyhistory loop.
variable is the variable that is to be referenced.
fieldID (optional) is the variable’s field. This is relevant for variable types that are represented by multiple fields, as for example multi and grid questions in a survey.
Example:
p4858585.response:Q1.1
This refers to the field with code 1, in a multi or grid question Q1, from the response (survey) data of a survey with survey id p4858585.
“Other Specify” answer categories
To reference categories that have an "Other, specify" text response, you can use the $other function to specify the category code type. For instance, for a "rating" question with an "Other, specify" category for answer code 99, you could write the following:
survey:rating.99$other