Skip to main content

How do I create custom measures in Insights on the Assignar dashboard?

A custom measure in Insights on the Assignar dashboard is a column you calculate yourself from other columns in a report, for example hours worked minus hours allocated.

A custom measure in Insights on the Assignar dashboard is a column you calculate yourself from other columns in a report, for example hours worked minus hours allocated. In Report Builder it's called a table calculation. You need an Insights Creator Licence.

Create a custom measure in Insights on the Assignar dashboard

To create a custom measure in Insights on the Assignar dashboard:

  1. In Insights > Report Builder, add every field the calculation uses and click Run.

  2. Click Calculations.

  3. Enter a name for the measure.

  4. Choose a format: decimal, currency or percentage.

  5. Type the formula, using the fields in the report and the operators below. As you type a field's name, the editor suggests matching fields; pick one to add it.

  6. Click Save Table Calculations.

The new column appears in the results in green. To add another, repeat the steps; a report can hold several.

If you save the report to the Group folder, everyone in your company with Insights can see the custom measure.

Operators and functions for custom measures in Insights

The tables below show what you can use in a custom measure in Insights on the Assignar dashboard.

Operators for numbers and comparisons:

Operator

Example

Result

+-*/

value_1 + value_2

Adds, subtracts, multiplies or divides.

= and !=

value_1 = value_2

Yes if equal (or not equal), otherwise No.

><>=<=

value_1 > value_2

Yes or No. Numbers and dates only.

Functions for text:

Function

Result

concat(value_1, value_2, ...)

Joins the values into one piece of text.

lower(string)

The text in lower case.

upper(string)

The text in upper case.

Functions for dates:

Function

Result

diff_days(start_date, end_date), diff_hours, diff_minutes, diff_seconds, diff_months, diff_years

The number of days, hours, minutes, seconds, months or years between two dates.

extract_days(date), extract_hours, extract_minutes, extract_seconds, extract_months, extract_years

That part of the date.

now()

The current date and time.

Row function:

Function

Result

offset(column, row_offset)

The value from another row of the same column, row_offset rows away.

Custom measures in downloads from Insights

When you download a report from Insights on the Assignar dashboard, custom measures are included as columns. You can't move a custom measure column to a different position in the download. See How do I download an Insights report or dashboard on the Assignar dashboard?.

Related articles

Did this answer your question?