iSEEK Supercruncher

Return to iSEEK Supercruncher.

Child pages
  • Custom Expression Examples

Versions Compared

Old Version 16

changes.mady.by.user Kevin MacClay

Saved on

compared with

New Version 17

changes.mady.by.user Kevin MacClay

Saved on

Key

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

...

Using Metrics from Different Reports

Tip
titleReferring to Other Reports

By default, metrics used within a custom expression always use the current report as a filter of the data. However, by qualifying the metric with the name of a report, you can force the filters of that report to be applied when calculating the metric.

For example, this represents the average score within the current report:

Code Block

[Average: Score]

This represents the average score in the state of Utah, regardless of what the current report is: (assuming there is a report named "Utah Students")

Code Block

[Average: Utah Students: Score]

Example: Percentage of students who are proficient.

...

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

Using Overall Metrics from Different Reports

Example: Benchmarking my schools' performance against state-wide or application-wide performance.

...