Use Basic Functions in Report Studio

ClickTime’s Report Studio offers a range of basic functions to support calculations, summaries, and comparisons within your reports. Depending on where you're building your formula—Metric Editor or Attribute Editor—the list of available functions may vary slightly.

These functions are great for totaling hours, calculating averages, identifying highest/lowest values, and performing other common business calculations.

In the Metric Editor

The Metric Editor is where you'll define custom metrics that perform aggregations or calculations on your report data. The following functions are available when building metrics:

Add(Value1, Value2, …)

Adds two or more values together.

Average(Value1, Value2, …)

Returns the average (arithmetic mean) of the listed values.

Avg(Attribute)

Returns the average value of an attribute or metric across the dataset.

Count(Attribute)

Counts the number of entries or rows with a non-null value.

First(Attribute)

Returns the first value in a list (based on the report’s sort order).

GeoMean(Value1, Value2, …)

Returns the geometric mean. Useful for ratio-based or financial analysis.

Greatest(Value1, Value2, …)

Returns the highest value from the list.

Last(Attribute)

Returns the last value in a list (based on sort order).

Least(Value1, Value2, …)

Returns the lowest value from the list.

Max(Attribute)

Returns the maximum value from a set.

Median(Attribute)

Returns the median (middle) value of a dataset.

Min(Attribute)

Returns the minimum value from a set.

Mode(Attribute)

Returns the most frequently occurring value.

Product(Value1, Value2, …)

Multiplies all values together (useful for compounding or scaling).

Stdev(Attribute)

Returns the sample standard deviation.

StdevP(Attribute)

Returns the population standard deviation.

Sum(Attribute)

Returns the total sum of a given attribute or metric.

Var(Attribute)

Returns the sample variance.

VarP(Attribute)

Returns the population variance.

Level(Metric, Attribute)

Allows you to calculate values at a specific grouping level, overriding the report's default grouping.

Example: Level(Sum([Hours]), [Employee]) totals hours by employee even if the report is grouped by department.

In the Attribute Editor

The Attribute Editor allows you to define new columns (custom attributes) using row-level logic—more like formulas in a spreadsheet. These functions are available in this context:

Add(Value1, Value2, …)

Adds two or more values.

Example: Add([Base Hours], [Additional Hours])

Average(Value1, Value2, …)

Returns the average of two or more values.

Example: Average([Q1 Hours], [Q2 Hours])

Greatest(Value1, Value2, …)

Returns the highest value from the list.

Example: Greatest([Q1], [Q2], [Q3])

Least(Value1, Value2, …)

Returns the lowest value from the list.

Example: Least([Vacation Hours], [Sick Hours])

Multiply(Value1, Value2)

Multiplies two values together.

Example: Multiply([Total Hours], [Billing Rate])

Tips for Using Basic Functions

• Metric functions typically summarize or aggregate data across rows.

• Attribute functions calculate on a row-by-row basis and appear as new columns in your report.

• Combine these functions with logical, date, or null-handling functions for advanced formulas.

Exploring Further

To see all available functions, open the Formula Editor in either the Metric or Attribute panel. Each function includes syntax guidance and a short description to help you get started.

Need help choosing between a metric or an attribute for your formula? Reach out to the Support Team—we’re happy to help!