Minute / Temporal Layer

Extract minutes from datetime values, similar to datetime.minute in Python or EXTRACT(MINUTE FROM timestamp) in SQL. Returns integers from 0 to 59.

Example extractions:

Input Datetime	Minutes	Note
2024-01-15 12:00:45	0	Hour start
2024-01-15 12:30:00	30	Mid-hour
2024-01-15 12:59:59	59	Hour end

Common applications:

Time-based grouping
Scheduling analysis
Activity patterns
Interval calculations
Traffic analysis

Table

Transforms

[, ...]

Select

column

Datetime column to extract minutes from. Returns minute component only, ignoring seconds and smaller units. Values wrap from 59 to 0 at hour boundaries.

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.