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

      Reporting on Multi-Valued Fields

      • Updated 08 Nov 2023
      • 1 minute read
      • Print
      • 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?
      What's Next

      157 Church Street, 22nd Floor
      New Haven, CT 06510

      Solutions
      Resources
      About
      Like and subscribe

      © 1994-2024 Technolutions. All Rights Reserved Worldwide. The Technolutions word and graphic marks are registered trademarks of Technolutions.
      Change password!
      Changing your password will log you out immediately. Use the new password to log back in.
      Change profile
      Success!
      First name must have atleast 2 characters. Numbers and special characters are not allowed.
      Last name must have atleast 1 characters. Numbers and special characters are not allowed.
      Enter a valid email
      Enter a valid password
      Your profile has been successfully updated.
      Logout