Alerts Issue: Comparing Two Dynamic Values

This requires Builder privileges.

Issue:

Sending an alert if a max or min value is exceeded. Comparing the two variable values to fire an alert.

Resolution:

In order to use expressions, the first thing we need is to have a value in each of the data columns we are comparing. As you can see from my example, I have daily bookings for each person. I would like an alert to fire if the representatives are scheduled over their max booking limit.

Using expressions, I am able to add a new column that uses a Boolean value. 

if ( y1 >= y2 ) { 0;} else {1;}

With this formula, as long as the representatives stay at or under their max bookings, the alert won't fire. Once the representatives go over their Max Bookings, the alert value changes to 1 and the message is fired off.

This shows the setup of the expression within the Axis Label. You can hide the expression and still use it in your alert rule.

In Chart Designer

Create a JavaScript Expression

Define the Expression

When configuring alerts, be sure you use calculated field = 1 (default)

Expressions are not limited to just comparing values. If you have a standard deviation or other statistical calculations, you can also incorporate that into your chart. 

For More Information:

JavaScript: Derived Columns

iDashboards Builder Manual 14. Analytics

iDashboards Admin Manual 17. Alerts

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