Week / Temporal Layer

Extract ISO week number from date/datetime values, similar to datetime.isocalendar()[1] in Python or WEEK() in SQL. Returns integers from 1 to 53 following ISO 8601 standard.

Example extractions:

Date	Week	Note
2024-01-01	1	First week
2024-07-15	29	Mid-year
2024-12-31	53	Last week (leap year)
2023-12-31	52	Last week (regular)

Common applications:

Retail week analysis
Production planning
Weekly reporting
Sprint planning
Sales cycles

Table

Transforms

[, ...]

Select

column

Date/datetime column to extract ISO week number from. Week 1 is the first week with four or more days in January. Some years have 53 weeks.

Name 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.