iSEEK Supercruncher

Return to iSEEK Supercruncher.

Child pages
  • Custom Expression Examples

Versions Compared

Old Version 19

changes.mady.by.user Kevin MacClay

Saved on

compared with

New Version 20

changes.mady.by.user Kevin MacClay

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This expression requires that the Proficient Students report first be created. This report must contain what you would consider to be the proficient students, such as those with an "Average Most Recent Submission Score" between 4 and 6.

Note
titleFiltering by AggregatesCaution on filtering by aggregates.

You can not yet filter by an aggregate that is calculated on the fly. So if you have a report with a Score field, you can not create a filter that says "students who had an Average Score >= 4". You will need to have the Average Score as a pre-computed field in the data set.

Note
titleBe careful of what filters are being compared.

In this example, countOfMyStudents refers to all students within the current report. Keep in mind that the Proficient Students report may only be applying a filter against the Score field. Therefore, if you apply this expression to a report named Utah Students, but the Proficient Students report does not also filter by Utah, then you will be comparing the number of Utah students to all Proficient students. Currently, the solution is to create a Utah Proficient Students report.

Code Block
countOfProficientStudents = [Distinct Count: Proficient Students: Student ID];
countOfMyStudents = [Distinct Count: Student ID];
percentageProficient = round(countOfProficientStudents / countOfMyStudents * 100, 2)

...