Skip to main content

List of functions

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.