Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Apply Functions to a Simple Metric

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.

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.

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

Use a Comparison to Create a Textual Result

  • No labels