Guide
ABS
Returns the absolute value of a number
ABS([Delta])
AVG
Returns the avg of a series of numbers
AVG([Price] + ([Price] * [Tax Rate])/100)
AVGIF
Returns the conditional avg of a series of numbers
AVGIF([Price] + ([Price] * [Tax Percent])/100, [Price] > 0)
CEIL
Rounds a number up to the next largest whole number or integer
CEIL([Lead Time])
COUNT
Returns the count of values
COUNT([ID])
COUNT_DISTINCT
Returns the distinct count of values
COUNT_DISTINCT([ID])
COUNTIF
Returns the conditional count of values
COUNTIF([ID], [Project] != 'OS')
COUNTIF_DISTINCT
Returns the conditional count of values
COUNTIF_DISTINCT([ID], [Project] != 'OS')
DATEDIFF
Returns the difference between the specified start date and end date
DATEDIFF([Created On], [Completed On], 'year')
DATEPART
Returns provided date part of date as a number
DATEPART([Created On], 'year')
DIFFERENCE
Returns the running difference for the given expression between current value and previous
DIFFERENCE(SUM([Hours Spent]))
LENGTH
Returns the length of text
LENGTH('Hulk')
MAX
Returns the max of a series of numbers
MAX([Price] + ([Price] * [Tax Rate])/100)
MAXIF
Returns the conditional max of a series of numbers
MAXIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)
MEDIAN
Returns the median of a series of numbers
MEDIAN([Price] + ([Price] * [Tax Rate])/100)
MIN
Returns the min of a series of numbers
MIN([Price] + ([Price] * [Tax Rate])/100)
MINIF
Returns the conditional min of a series of numbers
MINIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)
PERCENTILE
Returns the value at a given percentile of a dataset
PERCENTILE([Price] + ([Price] * [Tax Rate])/100, 0.3)
ROUND
Rounds a number
ROUND([Price] + ([Price] * [Tax Rate])/100)
RUNNING_AVG
Returns the running avg for a given expression from the first row to the current.
RUNNING_AVG(SUM([Hours Spent]))
RUNNING_MAX
Returns the running max for a given expression from the first row to the current
RUNNING_MAX(SUM([Hours Spent]))
RUNNING_MIN
Returns the running min for a given expression from the first row to the current
RUNNING_MIN(SUM([Hours Spent]))
RUNNING_SUM
Returns the running sum for a given expression from the first row to the current
RUNNING_SUM(SUM([Hours Spent]))
STDEV
Returns the standard deviation of a series of numbers
STDEV([Price] + ([Price] * [Tax Rate])/100)
SUM
Returns the sum of a series of numbers
SUM([Price] + ([Price] * [Tax Rate])/100)
SUMIF
Returns the conditional sum of a series of numbers
SUMIF([Price] + ([Price] * [Tax Rate])/100, [Tax Rate] > 0)
TOTAL
Returns the total for a given aggregation across the whole dataset
TOTAL(SUM([Price]))