Quarter / Temporal Layer
Extract quarter number from date/datetime values, similar to pandas quarter or SQL QUARTER(). Returns integers from 1 to 4.
Quarter definitions:
| Quarter | Months | Common Terms | Fiscal Year* |
|---|---|---|---|
| Q1 | Jan-Mar | Winter/Q1/FQ3 | Q3 |
| Q2 | Apr-Jun | Spring/Q2/FQ4 | Q4 |
| Q3 | Jul-Sep | Summer/Q3/FQ1 | Q1 |
| Q4 | Oct-Dec | Fall/Q4/FQ2 | Q2 |
| *For fiscal years starting in July |
Common applications:
- Quarterly reports
- Financial analysis
- Business planning
- Performance reviews
- Seasonal trends
Table
0
0
Table
Transforms
[, ...]Select
columnDate/datetime column to extract quarter from. Returns calendar quarter number (1-4), where Q1=Jan-Mar through Q4=Oct-Dec.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.