Reporting on Multi-Valued Fields

Multi-valued fields allow records to have more than one value in a single field, such as housing multiple academic interests for a prospective student in a single field. Given this one-to-many relationship (e.g., one prospective student to their many possible academic interests), you will need to report on this differently than other one-to-one data (e.g., reporting by application type).

We've detailed the broad steps to build such a report below.

mceclip6.png

 

Adding the Report Part
  1. Add a new part to your report by clicking on "Data/Charts"
  2. Specify a Name, and then select:
    • Type of "Configurable Joins" 
    • Category of "Related"
    • Base of "Field Values"
  3. Click save
mceclip0.png
Adding Filters and Joins to the Report Part
  1. After completing the steps above, click "Edit" on the top right of the report part
  2. Add the "ID" filter, entering the field ID for the field you want to report on
  3. If you want to filter the results of this overall report part, you can continue adding any needed joins or filters. For instance, if the field you are reporting on is:
    • 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"
mceclip0.png
Configuring Columns and Rows
You will want to add the necessary columns and rows to your report, which you can learn about here. Since you might be reporting on fields using prompts, you will want to follow the instructions below to get at that information:
  1. After adding a "Data Table" as a row, for instance, 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
  2. Add the desired exports. Referencing our example on the right, we want to breakdown values in the "major" field by category, which represents the type of major, and then by value, which is the major itself
mceclip1.png

 

Was this article helpful?
1 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.