Built-in Functions → quarterDay

quarterDay() is a conversion function that returns the count of days from the beginning of the quarter for a given date or timestamp.

Note

To return the quarter’s count of days for the current date, use the quarterDay() conversion function without a parameter.

Signature

quarterDay(date_timestamp exp)

The following table illustrates the quarterDay() function parameter:

Parameter Description
date_timestamp exp The date or timestamp value to determine the quarter’s day number from

Returns

int representing the count of days of a quarter for a given date or timestamp.

Examples

  • Identify the day number of the quarter for the given date, 04/24/2020.
quarterDay(
	date(
		"2020-04-24"
	)
)

The given date is April 24th. Thus, the quarterDay() of the second quarter (Q2: April, May, and June) is 24 since the quarter starts in April.

  • Identify the day number of the quarter for the given timestamp, 02/06/2021 03:09:11.
quarterDay(
	timestamp(
		"2021-02-06 03:09:11"
	)
)

The given timestamp is February 6th 03:09:11 and January has 31 days. Thus, the quarterDay() of the first quarter (Q1: January, February, and March) is (31 + 6) = 37.

The following table illustrates the behavior of the quarterDay() conversion function:

Product Revenues quarterDay(date) quarterDay(timestamp)
CD $200 24 37
Hard disk $600 24 37
Cable $550 24 37
Hardware $800 24 37
Memory Card $220 24 37

Use the following steps for detailed instructions on how to use the quarterDay() conversion function to tackle the first example above in an insight:

Note

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:

    • Double-click the first quarter function, quarterDay(date_timestamp exp), to add the formula to the editor.
    • In the Formula Editor, replace date_timestamp exp with date("2020-04-24")
    • Select Validate & Save.
  • In the Properties panel, for Column Label, enter quarterDay().
  • Name the insight Revenue Per Category.
  • In the Action bar, select Save.