🔍 Custom points, trends and counters with AREE expressions and functions

When raw data is no longer enough, create your own trends.
Advanced calculations? AREE handles them with expressions and functions.
For every need, an expression. For every expression, an answer.

🎯 Why use expressions in AREE?

AREE goes far beyond simple data collection.
Expressions, operators, and logical, mathematical or statistical functions — everything you need to build calculated trends, virtual points, smart counters and alarms truly aligned with your constraints.

This flexibility enables precise analysis: threshold exceedances, moving averages, complex conditions, time-based filtering, cumulative durations… and much more.

🧩 Use case: time above 22°C

One expression… and everything becomes clear.

A client wants to trigger an alarm if the temperature exceeds 22°C for more than 40 hours over a year.

The challenge: a standard delay doesn’t work, since the duration resets every time the temperature drops below the threshold.

The solution relies on a calculated trend using the Duration function — often overlooked, yet extremely powerful.

Expression used:

Result:
➡️ AREE automatically calculates, day after day, the cumulative time spent above 22°C.
➡️ The latest value always reflects the current state of the year.
➡️ This data can be used directly in a dashboard or an alarm.

In other words:
Exceeded 40 hours? AREE tells you.

💡 Another application: cleanrooms

By combining expressions with schedules and calendars, it becomes possible to calculate, for example, the percentage of time each month where temperature and humidity remain within defined ranges — only during specific time slots and excluding maintenance days.

🔧 A quick technical look

AREE includes a wide range of operators and functions:

Logical: IF, AND, OR, NOT…
Mathematical: ABS, LOG, SQRT, ROUND…
Statistical: COUNT, AVERAGE, MAX…
Text: LEFT, MID, TEXT…
Trend-specific functions: AveragePeriod, InstantPeriod, Duration

With these building blocks, you can model your business rules, create smart trends, and build indicators perfectly tailored to your needs.

🚀 In summary

Creating an alarm, an indicator, or a calculated trend is no longer limited by your tools.
With AREE expressions, you define your own rules, your own analyses, and your own answers.