Analytics: Prevent Duplicate Rows Per Student

When reporting on student data, you may notice duplicate rows for one student, when you want each student condensed into one row. Here's a quick highlight of the filters you'll want to use as defaults.

Primary Education = (yes)

You'll want to be sure to add this filter - it will make sure that it is only scoping to the student's education at your institution.

Navigate to the Educations field picker, on the left side of the report. Locate the the Primary? (Yes/No) dimension and click Filter:

This will auto-add to your list of filters at the top of the page:

Name vs Name List

Using a Name List will identify the full list associated with each student, and add that information in one row, instead of separate rows for each unique name. A common example for this is in pulling the Course Name.

Instead of adding "Name" (highlighted in the screenshot below), you'll need to click "Name List" in the Measures subsection.

That will consolidate them on the right side of your report:

Name Lists are available for a variety of features in the Student template, such as:

• Career Interests
• Educations - Colleges
• Institution Labels
• Courses
• Organisations
• Level of Study