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.

Did this answer your question?