Condition panel for date/time attributes#

Anytime we want to construct a condition on a date, week, month, quarter or datetime 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 datetime attribute (date, week, month, quarter or datetime) 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 datetime form of the condition will be enabled, allowing the user to insert the right value of comparison. At the same time a new handler will be added to the below slider giving immediately to the user the visual representation of the considered interval.

Right term value can be selected:

By writing directly on the datetime field the desired threshold value.
By selecting the datetime from the calendar helper located on the left of the datetime field.
By moving the corresponding handler on the slider.

Important

New datetime 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 datetime form of the condition will be also enabled, allowing the user to complete the interval condition. At the same time 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

Drag and drop an integer or continuous attribute from the Attribute list to one of the Filter area to open the ordered condition panel.
Select the type of right operator for your condition.
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.
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.
Click Apply to construct the condition, Cancel to discard your changes.

For datetime 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 whole list of possible function available for the current attribute type.

Attribute type	Functions
date	Year Quarter Month Week Day
week	Year Week
month	Year Month
quarter	Year Quarter
datetime	Date Year Quarter Month Week Day Time Hour Minute Second

Note

Datetime form fields to control threshold values are accordingly modified with respect to the function selected. In particular, the Calendar icon located on the left of the field shows a set of views always different to guide the user to define the necessary threshold.

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:

First you set the left operators
Then you can decide the threshold attribute, by using the attribute drop down menu.

Procedure

Drag and drop an integer or continuous attribute from the Attribute list to one of the Filter area to open the ordered condition panel.
Click on the Attributes entry in the condition type radio button.
Select the type of the right operator for your condition.
Select the compared attribute from the the attribute drop down menu.
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.
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:

First you set the left operators
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

Drag and drop a nominal attribute from the Attribute list to one of the Filter area to open the nominal condition panel.
Click on the Code entry in the condition type radio button.
Select the type of the right operator for your condition.
Write your free GOLD code in the dedicated right text area
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.
Click Apply to construct the condition, Cancel to discard your changes.