Reporting on Multi-Valued Fields
  • 08 Nov 2023
  • 1 minute read
  • Dark
    Light
  • PDF

Reporting on Multi-Valued Fields

  • Dark
    Light
  • PDF

Article summary

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?