Page History

Panel

Table of Contents

Apply Functions to

...

Simple Metric

Example: Rounding the average test score to two decimal places.

...

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

Example: What is the average of all dimensional scores?

Code Block


dim1Total = [Total: Dimension 1 Score];
dim2Total = [Total: Dimension 2 Score];
dim3Total = [Total: Dimension 3 Score];
dim4Total = [Total: Dimension 4 Score];
dim5Total = [Total: Dimension 5 Score];

overallTotal = sum(dim1Total, dim2Total, dim3Total, dim4Total, dim5Total);
overallCount = [Count: Session ID];

round(overallTotal / overallCount, 2)

Example: What scoring dimension had the lowest average score?

Use variables to hold the average of each of the dimensional scores. Use min(...) function to find the lowest dimensional score. Use nested if (cond, trueValue, falseValue) blocks to return which dimension matches the lowest score. Note: If more than one dimension shares the same lowest score, this only returns the first dimension found.

Code Block


dim1Avg = [Average: Dimension 1 Score];
dim2Avg = [Average: Dimension 2 Score];
dim3Avg = [Average: Dimension 3 Score];
dim4Avg = [Average: Dimension 4 Score];
dim5Avg = [Average: Dimension 5 Score];

lowestScore = min(dim1Avg, dim2Avg, dim3Avg, dim4Avg, dim5Avg);

if (dim1Avg == lowestScore, "Dimension 1",
    if (dim2Avg == lowestScore, "Dimension 2",
        if (dim3Avg == lowestScore, "Dimension 3",
            if (dim4Avg == lowestScore, "Dimension 4",
                if (dim5Avg == lowestScore, "Dimension 5",
                    "Unknown"
                )
            )
        )
    )
)

Compare two or more Metrics

...

Child pages

Versions Compared

Old Version 7

New Version 8

Key