Condition panel for time attributes

Anytime we want to construct a condition on a time attribute, a dedicated condition construction panel will be presented, guiding you in condition definition.

Conditions can be constructed with three base types of comparison:

  • Values: the condition compares the attributes with respect to some fixed threshold values.

  • Attributes: the condition compares the attribute with other attributes. Comparison is made row by row.

  • Code: the condition compares the attribute with a free GOLD code thresholds.

You can select the type of comparison you want to construct by operating on the radio button present in the upper side of the condition panel. The form of the panel below the radio button choice slightly differs with respect to the comparison type. Therefore, we are going to describe each comparison type into a dedicated section.

Defining a value condition

If you want to construct a condition for a time attribute comparing its values against some fixed thresholds, you need first to define the thresholds.

First you need to specify the right operator you want to use for your condition and the right value to be used as upper threshold. The right operator can assume the following values:

  • ==

  • !=

  • <

  • <=

  • >

  • >=

Only once you have defined a not null right operator the right time form of the condition will be enabled, allowing the user to insert the right value of comparison. In the same moment, a new handler will be added to the below slider giving immediately to the user the visual representation of the considered interval.

Note

Rulex Platform time attribute are not cyclical meaning the number of hour can overcome 24. The time attribute always represents an elapsed time more than a date time.

Right term value can be selected:

  • By writing directly on the time field the desired threshold value. A helper mask will guide the user in typing the right format for the time which is (H)HH:MM:ss.000000.

  • By moving the corresponding handler on the slider.

Important

New time condition construction always starts from the right operator which is the unique not disable field just after panel opening. Moreover left operator and left threshold value are necessary only when you want to construct interval condition.

To construct an interval condition, you can operate also with the left operator. The left operator can only assume the following cases:

  • < (if the right operator is < or <=)

  • <= (if the right operator is < or <=)

  • > (if the right operator is > or >=)

  • >= (if the right operator is > or >=)

Once even the left operator is defined to be not null, the left time form of the condition will be also enabled, allowing the user to complete the interval condition. In the same moment, a new handler will be added to the below slider. Methods to modify the left term value are exactly equal to the right one.

Tip

  • If you right-click on any of the handlers available on the slider track you will change the border operator. If the handler is filled it means the selected value is included in the range (left or right operator are <= or >=), if it is empty it means the selected value is excluded from the range (left or right operator are < or >).

  • If you right-click on any point of the track you will select this range of the track, completely inverting in many cases precedent filter.

Finally, dropdown menu located at the bottom end of the panel states the policy you want to apply to None values. In particular:

  • Exclude: it will prevent None value lines to verify the condition.

  • Include: all None value lines will verify the condition.

Even in this case a right-click on the separated None slider track will invert Exclude with Include values and vice versa.

Procedure

  1. Drag and drop an integer or continuous attribute from the Attribute list to one of the Filter area to open the ordered condition panel.

  2. Select the type of right operator for your condition.

  3. Select the right condition threshold. In particular, you can:

    • Write directly the desired number in the dedicated text area.

    • Select one the suggested values related to attribute Mean and Standard deviation

    • Move the slider handler up to the desired value.

    • Select the policy to apply to None values by using the dedicated drop down menu.

  4. If you want to consider an interval condition you need to the select the left condition operator and the left condition value. You can follow the same behavior suggested before.

  5. Click Apply to construct the condition, Cancel to discard your changes.

For time attribute, condition can be constructed for the attribute itself or for functional modification of the selected attribute. To apply a function to the considered attribute you need to click on the Pencil icon located at the right of the attribute name. This will open a dedicated function menu containing the following list of functions:

  • Hour

  • Minute

  • Second

Note

When one of these function is selected, panel is modified accordingly becoming a standard ordered condition panel controlling the hour/minute/second of the selected attribute.

Defining an attribute condition

If you want to construct an attribute comparison among a provided attribute and up to two thresholds attributes, you first need to define the right side operator.

In particular, right available operators are:

  • ==

  • !=

  • <

  • <=

  • >

  • >=

  • is

  • not is

Once you have decided the right operator you can select the right threshold attribute by using the attribute drop down menu.

If you want to construct an interval condition, we need to follow the same order:

  1. First you set the left operators

  2. Then you can decide the threshold attribute, by using the attribute drop down menu.

Procedure

  1. Drag and drop an integer or continuous attribute from the Attribute list to one of the Filter area to open the ordered condition panel.

  2. Click on the Attributes entry in the condition type radio button.

  3. Select the type of the right operator for your condition.

  4. Select the compared attribute from the the attribute drop down menu.

  5. Eventually if you want to construct an interval condition, you need to select the type of the left operator for your condition. Then it is mandatory to provide also a left threshold attribute to complete the condition code.

  6. Click Apply to construct the condition, Cancel to discard your changes.

Defining a code condition

If you want to construct an attribute comparison among a provided attribute and up to two thresholds filled with free GOLD codes, you first need to define the right side operator.

In particular, right available operators are:

  • ==

  • !=

  • <

  • <=

  • >

  • >=

  • is

  • not is

Once you have decided the right operator you can write your free GOLD code in the dedicated right text area. This free GOLD code can include both variables or other attributes references.

If you want to construct an interval condition, we need to follow the same order:

  1. First you set the left operators

  2. Then you can decide the free GOLD code to be used as left term.

Note

In code conditions if you want to add None value on top of the inserted comparison, you can check the Include None Values checkbox present in the code condition panel.

Procedure

  1. Drag and drop a nominal attribute from the Attribute list to one of the Filter area to open the nominal condition panel.

  2. Click on the Code entry in the condition type radio button.

  3. Select the type of the right operator for your condition.

  4. Write your free GOLD code in the dedicated right text area

  5. Eventually if you want to construct an interval condition, you need to select the type of the left operator for your condition. Then it is mandatory to provide also a left threshold free GOLD code to complete the condition code.

  6. Click Apply to construct the condition, Cancel to discard your changes.