Condition panel for date/time attributes¶

Anytime you 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 defining the condition.

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¶

Before constructing a condition for a datetime attribute (date, week, month, quarter, or datetime) by comparing its values to fixed thresholds, it is essential to start by defining those 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 valid 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 slider located at the bottom of the panel, giving immediately to the user the visual representation of the considered interval.

Right term values 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 only enabled field after opening the panel. Moreover, left operator and left threshold value are necessary only when you want to construct an interval condition.

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

< (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 the left operator has been defined, the left datetime form of the condition will also be enabled, allowing the user to complete the interval condition. At the same time a new handler will be added to the slider at the bottom of the panel. Methods to modify the left term value are exactly the same as those in 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 the previous filter.

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

Exclude: it prevents None value lines to verify the condition.
Include: it includes all None value lines to 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 a date attribute from the Attribute list to the Pre-filter or Post-filter area to open the date 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 attributes, the conditions 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, available right 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, you need to follow the same order:

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

Procedure

Drag and drop a date attribute from the Attribute list to the Pre-filter or Post-filter area to open the ordered condition panel.
Click on the Attributes entry in the condition type radio button.
Select the right operator type 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 left operator type 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, or 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, available right 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, you need to follow the same order:

First, you need to 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 date attribute from the Attribute list to the Pre-filter or Post-filter area to open the date 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, or Cancel to discard your changes.