Within the custom metrics builder you can calculate new metrics using functions similar to those found in Excel.

To use functions, click the Function button under the formula bar. This will display a list of available functions for your account.

For companies on the team plan, here is a list of available functions and their description:

MA | Calculates the moving average for a specific increment of time

XIRR | Returns the internal rate of return for a series of cash flows that may not be periodic

CGR | Returns the compounded growth rate for any metric

SGR | Returns the simple growth rate for any metric

SUM | Adds all numbers in a range of data

COUNT | Counts the number of periods that contain numbers

AVERAGE | Returns the average of the numbers provided

SUMIF | Adds all numbers in a range of cells based on one criteria

COUNTIF | Counts the number of periods in a range, that meets a given criteria

COUNTA | Counts the number of periods in a range that are not empty

AVERAGEIF | Returns the average of all numbers in a range of cells, based on a given criteria

MAX | Returns the largest value from the numbers provided

MIN | Returns the smallest value from the numbers provided

MEDIAN | Returns the median of the numbers provided

MODE | Returns most frequently occurring number

LARGE | Returns the nth largest value from a set of values

SMALL | Returns the nth smallest value from a set of values

STDEV | Returns the standard deviation of a population based on a sample of numbers

VAR | Returns the variance of a population based on a sample of numbers

If you would like to use a function not available on this list, send us a note and we will add that function to your plan.