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.