quarter function
The quarter function returns the first month of the corresponding quarter of the date attribute. The results will always be:
1, if the date attribute is in the first quarter, from January to March:
4, if the date attribute is in the second quarter, from April to June;
7, if the date attribute is in the third quarter, from July to September;
10, if the date attribute is in the fourth quarter, from October to December.
If the extract parameter is True, the corresponding quarter is displayed.
Parameters
quarter(date, extract)
Parameter | Description |
---|---|
date | The date, week, month, quarter or datetime attribute if the extract parameter is False to retrieve the month value. If the extract parameter is True, all attribute types can be used. The date parameter is mandatory. |
extract | A binary value (True/False) which is set as False as default. If True, the function returns the corresponding quarter. The binary parameter values (True/False) are case sensitive. |
Date type valid formats (if the values aren’t this format, the function will return an error).
2019/10/12;
12/10/2019;
2019-10-12;
12-10-2019;
2019/Oct/12;
12/Oct/2019;
2019-Oct-12;
12-Oct-2019.
Week type valid formats (if the values aren’t this format, the function will return an error).
2019/W41;
W41/2019;
2019-W41;
W41-2019.
Month type valid formats (if the values aren’t this format, the function will return an error).
1492/10;
10/1492;
1492-10;
10-1492;
1492/Oct;
1492-Oct;
Oct/1492;
Oct-1492.
Quarter type valid formats (if the values aren’t this format, the function will return an error).
2019/Q3;
Q3/2019;
2019-Q3;
Q3-2019.
Datetime type valid formats (if the values aren’t this format, the function will return an error).
2019/05/22 17:33:45
Example
The following example uses the Instagram_data dataset.
Description | Screenshot |
---|---|
In this example, we want to retrieve the quarter of the Date Posted attribute. We want to be displayed the first month of the date’s corresponding order, so the formula will be:
The results can be read as follows:
|
In the following examples, you will see how the extract parameter changes the results.
Description | Screenshot |
---|---|
In this example, we want to retrieve the quarter of the Date Posted attribute. As we want the exact quarter, and not its first month, we need to specify the extract parameter as True. Add a new attribute, called quarter, and type the following formula:
|
This function returns completely different results when working using attributes whose type is different from those specified in the date parameter’s description:
In this use case, the starting date from which the function calculates the quarter is the default Rulex date, which is 1899-12-30, in order to return the corresponding date.
Description | Screenshot |
---|---|
In this example, we want to retrieve the quarter of the Month attribute. As its type is integer, the function must contain also the extract parameter. Add a new attribute and type the following formula:
As you can see, the function has returned values in quarter format. The Month attribute’s values are considered as the number of days to add to the default Rulex date, 1899-12-30:
|