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