We have been working hard so that you can now create your own custom measures within Insights.

In order to use this feature easily, bring all the columns you need in the Data Area. Then click on the Calculations Tab where you can use any of the below operators to build your own measure.

Now give your measure a name

Then select what format is the measure. Is it a decimal value or a currency value or a percentage value.

Now start typing the columns you want to use in your calculation.

Once the formula is set you can save this Table Calculations.

Once you save the Table calculations you will be able to see the green columns in the Report which indicate they are custom measures.

If you save this Report/Dashboard in group Reports/Dashboards other Insights users will also be able to access this custom measure created by you.

You can add more than 1 Table Calculation in a Report by adding more Table calculations.

Check out this handy video for more details: VIDEO : Custom Measures

For more Advanced functionality check out this video : Offset Measures

Operators that can be used are as follows :

Operator

Syntax

Purpose

+

value_1 + value_2

Adds value_1 and value_2.

-

value_1 - value_2

Subtracts value_2 from value_1.

*

value_1 * value_2

Multiplies value_1 and value_2.

/

value_1 / value_2

Divides value_1 by value_2.

=

value_1 = value_2

Returns Yes if value_1 is equal to value_2, and No otherwise.

!=

value_1 != value_2

Returns Yes if value_1 is not equal to value_2, and No otherwise.

The following comparison operators only can be used with numbers and dates:

Operator

Syntax

Purpose

>

value_1 > value_2

Returns Yes if value_1 is greater than value_2, and No otherwise.

<

value_1 < value_2

Returns Yes if value_1 is less than value_2, and No otherwise.

>=

value_1 >= value_2

Returns Yes if value_1 is greater than or equal to value_2, and No otherwise.

<=

value_1 <= value_2

Returns Yes if value_1 is less than or equal to value_2, and No otherwise.

The following functions only can be used with strings:

Function

Syntax

Purpose

concat

concat(value_1, value_2, ...)

Returns value_1, value_2, ..., value_n joined as one string.

lower

lower(string)

Returns string with all characters converted to lowercase.

upper

upper(string)

Returns string with all characters converted to uppercase.

The following functions only can be used with dates:

Function

Syntax

Purpose

diff_days

diff_days(start_date, end_date)

Returns the number of days between start_date and end_date.

diff_hours

diff_hours(start_date, end_date)

Returns the number of hours between start_date and end_date.

diff_minutes

diff_minutes(start_date, end_date)

Returns the number of minutes between start_date and end_date.

diff_months

diff_months(start_date, end_date)

Returns the number of months between start_date and end_date.

diff_seconds

diff_seconds(start_date, end_date)

Returns the number of seconds between start_date and end_date.

diff_years

diff_years(start_date, end_date)

Returns the number of years between start_date and end_date.

extract_days

extract_days(date)

Extracts the days from date.

extract_hours

extract_hours(date)

Extracts the hours from date.

extract_minutes

extract_minutes(date)

Extracts the minutes from date.

extract_months

extract_months(date)

Extracts the months from date.

extract_seconds

extract_seconds(date)

Extracts the seconds from date.

extract_years

extract_years(date)

Extracts the years from date.

now

now()

Returns the current date and time.

The following function is a row related offset function. See Dashboard Library -> Orders Reports.

Function

Syntax

Purpose

offset

offset(column, row_offset)

Returns the value of row (n + row_offset) in column, where n is the current row number.

Did this answer your question?