Trendz Analytics
Trendz Documentation
Cloud Professional Edition Community Edition IoT Gateway License Server Trendz Analytics
Try it now Pricing
Documentation > States
Getting Started

On this page


Simple state


In this example we have Machine device that submit how many details where produced. We want to find what is production rate of our machines.

Let’s define our states:

  • Low Production - amount of produced details < 75;
  • Moderate Production - amount of produced details between 75 and 110;
  • High Production - amount of produced details greater than 110;

Here is condition that chack does machine in Low Production state or not:

    double okRate = none(Machine.okDetails);
    return okRate < 75;

Here steps required to do this:

  • Create Bar chart
  • Add Date(RAW) to X-axis
  • Add State field and change title to Low Production
  • Change field aggregation to DURATION_PERCENT
  • Write formula for Low Production
  • Repeat last 3 operations for Moderate Production and High Production states
  • Enable stack mode, 100% stacked bar and labels in view settings



Our view ready and now we know how much time(in percent) machines spent in different states.

State with multiple fields


We can also use multiple fields from different assets\devices to calculate state. In this example we want detect how much time machines spent in critical state. Such visualisation will give an understanding how machine prorforms compered to other machines and when it should be maintained to prevent downtime.

We know that our machines is in critical state when pressure goes up and rotation speed goes down. So let’s find how much time spent in critical state.

Here is a formal definition of Critical state:

    double pressure = none(Machine.pressure);
    double speed = none(Machine.rotationSpeed);
    return pressure > 700 && speed < 35;
  • Create Heatmap chart
  • Add State field and change title to Critical
  • Change field aggregation to DURATION_PERCENT
  • Write formula for Critical state
  • Select hour vs day of week in By field

State Aggregation

Here is a list of supported aggregation functions for state fields:

  • Duration - total time spent in state inside group. In hours, minutes, seconds etc.
  • Duration percent - percent of time spent in state inside group.

Get original field value

Before applying transformation you need to get a reference to the original field value. Here is an example how to do this:

double temp = avg(Machine.temperature);
  • avg() - aggregation function
  • Machine - Entity Name (it can be Asset Type or Device Type)
  • temperature - Field Name

All 3 parts are required, you can not access original field value without aggregation function.

If original field value is an attribute, entity name or owner name - you should use uniq() aggregation function.

This template can be used for comparing text fields:

String currentState = none(machine.status);
return "running".equals(currentState);

Supported Aggregation Functions

State fields supports following aggregation functions:

  • none()
  • avg()
  • sum()
  • min()
  • max()
  • count()
  • latest()
  • uniq()
  • delta()

Each function allows only 1 argument - reference to the filed on format EntityName.fieldName. For example:


Commonly, states are used for calculating how much time device/asset spent in different states. To get more precise results it is recommended you use none() aggregation - in this case system will process only raw telemetry to define is device inside defined state or not.

Aggregation function applied to a grouped dataset. Find more details about Grouping and Aggregation in this article


In most cases amount of data analysed during state calculation is big enough. To guarantee performance function should be defined using Java language (Java 8).