Function List

Grafieks supports many functions for use in Custom field. To learn more about the functions in Grafieks, see the following article:

1. Aggregate Functions

An aggregate formula is a type of formula used to summarize or combine multiple values into a single result. Instead of working on individual data points, aggregate formulas operate across a group of records or data entries to produce insights such as totals, averages, counts, or maximum/minimum values.

SUM

Returns the total (sum) of all the values in the specified column.

Syntax:

Sum(column)

Example:

Sum([Sales]) would return the total of all values in the Sales field.

Average

Returns the average (mean) of the values in the column.

Syntax:

Avg(column)

Example:

Avg([Score]) would return the average value in the Score column.

MAX

Returns the largest (maximum) value in the column.

Syntax:

Max(column)

Example:

Max([Revenue]) would return the highest revenue value from the column.

MIN

Returns the smallest (minimum) value in the column.

Syntax:

Min(column)

Example:

Min([Temperature]) would return the lowest temperature from the dataset.

2. Logical Functions

Logical functions determine if a condition is satisfied or determine what value to return based on a condition. They are commonly used to evaluate expressions as TRUE or FALSE, and return results accordingly.

CASE

Returns values based on conditional logic. Similar to a series of IF-THEN statements.

Syntax:

    CASE
        WHEN condition THEN result
        [WHEN ...]
        [ELSE default_result]
    END

Example:

    CASE
        WHEN [Score] >= 90 THEN "A"
        WHEN [Score] >= 80 THEN "B"
        ELSE "C"
    END

IF

Returns one value if a condition is true, and another if it’s false.

Syntax:

IF(condition, true_result, false_result)

Example:

IF([Sales] > 1000, "High", "Low")
Returns "High" if sales exceed 1000, otherwise "Low".

OR

Returns true if any of the conditions are true.

Syntax:

OR(condition1, condition2, ...)

Example:

OR([Region] = "East", [Region] = "West")
Returns true if the region is East or West.

AND

Returns true if all conditions are true.

Syntax:

AND(condition1, condition2, ...)

Example:

AND([Status] = "Active", [Balance] > 0)
Returns true if both conditions are met.

NOT

Reverses the result of a condition. Returns true if the condition is false.

Syntax:

NOT(condition)

Example:

NOT([Status] = "Inactive")
Returns true if status is not "Inactive".

3. Math Functions

Perform arithmetic and numeric operations like absolute values, addition and more on numerical data.

ABS

Returns the absolute (positive) value of a number, removing any negative sign.

Syntax:

Abs(value)

Example:

Abs([-50]) would return 50.

ADD

Returns the result of adding two numbers or fields together.

Syntax:

Number1 + Number2

Example:

[Price] + [Tax]

Returns the total amount including tax.

SUBTRACT

Returns the result of subtracting one number or field from another.

Syntax:

Number1 - Number2

Example:

[Revenue] - [Cost]

Returns the profit by subtracting cost from revenue.

MULTIPLY

Returns the product of two numbers or fields.

Syntax:

Number1 * Number2

Example:

[Quantity] * [Unit_Price]

Returns the total value of items sold.

DIVIDE

Returns the result of dividing one number or field by another.

Syntax:

Number1 / Number2

Example:

[Total] / [Count]

Returns the average value per item.