Built-in Functions → quarterMonth
quarterMonth() is a conversion function that returns the month number of the quarter from the beginning of the quarter for the current date.
To return the quarter’s month number for a given date or timestamp, use the quarterMonth() conversion function with a parameter.
Signature
quarterMonth()
Returns
int representing the current quarter’s month number.
Example
Identify the month number of the quarter, for the current date, 08/26/2021.
quarterMonth()
The following table illustrates the behavior of the quarterMonth() conversion function:
| Product | Revenues | quarterMonth() |
|---|---|---|
| CD | $200 | 2 |
| Hard disk | $600 | 2 |
| Cable | $550 | 2 |
| Hardware | $800 | 2 |
| Memory Card | $220 | 2 |
August is the second month of the current quarter (Q3: July, August, and September). Thus, the quarterMonth() is 2.
Use the following steps for detailed instructions on how to use the quarterMonth() conversion function to tackle the above example in an insight:
In the Cluster Management Console (CMC), 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 Manage Dataset.
- 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:
- Category from the PRODUCTS table to the Grouping Dimension tray.
- Revenue from the SALES table to the Measure tray.
- In the Properties panel, for Number Format, select Dollar Rounded.
- 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 Conversion Functions.
- Double-click the second quarterMonth function,
quarterMonth(), to add the formula to the editor. - Select Validate & Save.
- In the Properties panel, for Column Label, enter quarterMonth().
- Name the insight Revenue Per Category.
- In the Action bar, select Save.
