Fields that store multiple values from a prompt list, also known as multi-valued fields, allow records to have more than one value in a single field, such as having multiple academic interests for a student in a single field. Given this one-to-many relationship (e.g., one student to their many possible academic interests), you will need to report on this differently than other one-to-one data.
We've detailed the broad steps to build such a report below.
Adding the Report Part
Add a new part to your report by clicking on "Data/Charts".
Specify a Name, and then select:
Type of "Configurable Joins"
Category of "Related"
Base of "Field Values"
Click Save.
Adding Filters and Joins to the Report Part
Enter the Edit Report Parts view by completing the steps above or editing an existing part.
Add the "ID" filter, entering the field ID for the field you want to report on.
To filter on the record itself, you’ll need to make a join based on the scope of the field:
Person-scoped, join from "Field Values" to "Person"
Application-scoped, join from "Field Values" to "Application"
Dataset-scoped, join from "Field Values" to "Dataset Row"
Configuring Columns
Next, you will want to add at least one column to your report. In the example above, there is only one column configured. This column has no filters and simply counts all of the field values in each row.
However, if you need multiple columns, you will need to make the same record join inside each column in order to target filters and joins on the record base:
Configuring Rows
Finally, you can configure the rows of your report. Since multi-valued fields use prompts, you will need to use the Prompt Value export on the Field Values base to see the data in your selected field.
If you want to export additional data about the prompt, join from "Field Values" to "Lookup Prompt". This will allow you to report on attributes about the field, such as their category or export value. The Value export on this base will export the same information as the Prompt Value export on the Field Values base.
In the example above, the row configuration uses the Category and Value exports on the Lookup Prompt base to display the type of major and the major itself.
