Math Functions as Expressions

This will require Builder privileges for setup and implementation.

In an iDashboards expression, you can use math functions! Yay! Math is fun!

• Math.abs(y₁) returns |y₁| the absolute value of y₁
• Math.round(y₁) rounds up if the fractional-part of y₁ >= 0.5 and rounds down if the fractional part of y₁ < 0.5
• Math.ceil(y₁) rounds up to the nearest whole number
• Math.floor(y₁) rounds down to the nearest whole number

Note: case matters.  Make sure the function (abs, round…) are in lowercase.

// number of milliseconds  in one hour
var ONE_HOUR = 1000 * 60 * 60

// convert dates to milliseconds
var startDate_ms = y1.getTime()
var endDate_ms   = y2.getTime()

// Calculate the difference |endDate - startDate|
var difference_ms = Math.abs(endDate_ms - startDate_ms)

// convert back to hours
Math.round(difference_ms/ONE_HOUR)

Example

If a driver leaves a location at a given start time and arrives at a destination at a given end time calculate the how many hours a driver was on the road.

Assign y₁ as Project Manager

Assign y₂ as the start date

Assign y₃ as the end date

For y₄ copy the expression below:

• • Math.abs(Y3 - Y2)/3600000

Tabular Chart with the Data

For More Information:

• OSKAR: Data Analytics
• Dashboard & Chart Design Articles
• iDashboards Builder Manual 14 Analytics
• For more functions see: JavaScript Math Library
• iDashboards Builder Manual 9.11 Tabular Charts
• iDashboards Builder Manual 8 Designing Charts

If the above is unable to resolve the issue, then please contact truOI Support for further assistance.