Built-in Functions → addQuarters
addQuarters() is a scalar date function that returns an updated date or an updated timestamp after adding the number of quarters as specified for the increment.
Signature
addQuarters(date_timestamp exp, int quarters)
The following table illustrates the addQuarters() function parameters:
Parameter | Description |
---|---|
date_timestamp exp | The date or timestamp value to which the quarters are being added |
int quarters | An integer representing the number of quarters to add |
Returns
Date
or timestamp
representing the updated time or timestamp after appending to the given quarter
Examples
Add 1 quarter to the date value, 05/02/2010.
addQuarters(date("2010-05-02"),1)
Add 2 quarters to the timestamp value, 05/02/2010 03:09:11.
addQuarters(timestamp("2010-05-02 03:09:11"),2)
Use the following steps for detailed instructions on how to use the addQuarters() function to create the above query:
Note
In the Cluster Management Console (CMC), you can create a tenant that includes Sample Data. The Sample Data includes the SALES schema.
- In the Navigation bar, select the Content tab, and then select + New → Add Dashboard.
- In the Add Dashboard dialog, for Name, enter Product Dashboard, and then select Add.
- In the Action bar, select + (add icon), or select + Add Insight.
- In the Insight panel, select Listing Table or V.
- In Tables, select Aggregated Table.
- In the Data panel, select Add Data Set (+).
- In the Manage Data Sets panel, in Tables, select SALES. Close the panel.
- From the Data panel, drag and drop the following columns to the respective tray:
- Revenue from the SALES table to the Measure tray.
- Category from the PRODUCTS table to the Grouping Dimension tray.
- From the Data panel, drag and drop Add Formula to the Grouping Dimension tray.
- The Formula Builder automatically opens:
- In Search Functions, select the down arrow, and then select Date Functions.
- Double-click the addQuarters function,
addQuarters(date_timestamp exp, int quarters)
, to add the formula to the editor. - In the Formula Editor,
- Replace
date_timestamp exp
withdate("2010-05-02")
- Replace
int quarters
with1
- Replace
addQuarters(date("2010-05-02"), 1)
- Select Validate & Save.
- In the Properties panel, for Column Label, enter addQuarters() date
- From the Data panel, drag and drop Add Formula to the Grouping Dimension tray.
- In Search Functions, select the down arrow, and then select Date Functions.
- Double-click the addQuarters function,
addQuarters(date_timestamp exp, int quarters)
- In the Formula Editor,
- Replace
date_timestamp exp
withtimestamp("2010-05-02 03:09:11")
- Replace
int quarters
with2
- Replace
- Double-click the addQuarters function,
addQuarters(timestamp("2010-05-02 03:09:11"), 2)
- Select Validate & Save.
- In the Properties panel, for Column Label, enter addQuarters() timestamp
- Name the insight addQuarters()
- In the Action bar, select Save.