Insights & Tips: Prevent Duplicate Rows Per Student

Shelby Marter -

When you're pulling a report on student data, you might notice that you see 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, in the left-hand column of the report. Find the Primary? (Yes/No) dimension and filter:

Screen_Shot_2018-03-27_at_11.08.02_AM.png

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

Screen_Shot_2018-03-27_at_11.08.08_AM.png

Name vs Name List

Pulling a Name List will identify the full list associated with the Student, and add that information in one row, instead of separate rows for each unique name. The most common example for this is in pulling the Major Name, as students will often have double Majors.

 So instead of adding "Name" (highlighted here), you'll want to select "Name List"

Screen_Shot_2018-03-27_at_11.15.05_AM.png 

 

And will consolidate them here in this section of your report:

Screen_Shot_2018-03-27_at_11.17.50_AM.png

 

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

  • Career Interests
  • Educations - Colleges
  • Institution Labels
  • Majors
  • Minors
  • Organizations
  • School Year

 

 

 

 

 

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request