Versions Compared

Key

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

...

Example: Rounding the average test score to two decimal places

Take the average test score and apply the round(x, p) function, setting the precision p equal to 2.

Code Block
round([Average: Test Score], 2)

Compare

...

two or more Metrics

Example: Student-Teacher Ratio

The number of students divided by the number of teachers. Distinct counts must be used here if the data contains more than one row per student or teacher.

Code Block

[Distinct Count: Student ID] / [Distinct Count: Teacher ID]

Use a Comparison to Create a Textual Result