United States
Browse categories to find relevant articles and insights.
No category selected
Year represents the specific year extracted from a DATETIME field, offering yearly granularity for analysis. Formatted as a 4-digit number, e.g., 2024.
Datetime represents a combined date and time value in the ISO 8601 format (YYYY-MM-DD HH:MM:SS ±HH:MM), ensuring precise temporal tracking with timezone support.
Date + Hour represents the specific date and hour extracted from a DATETIME field, enabling analysis at a combined granular level. Formatted as YYYY-MM-DD HH:00.
Day represents the specific day extracted from a DATETIME field, providing daily granularity for analysis. Formatted as a 2-digit number, 01–31.
Hour represents the specific hour extracted from a DATETIME field, enabling hourly granularity for analysis. Formatted as a 2-digit number, 00–23.
Month represents the specific month extracted from a DATETIME field, allowing for monthly granularity in analysis. Formatted as a 2-digit number, 01–12.
Nth Day represents the number of days since the start of the dataset or period, offering sequential day tracking. Formatted as an integer, e.g., 01.
Nth Hour represents the number of hours since the start of the dataset or period, providing sequential hour tracking. Formatted as an integer, e.g., 01.
Nth Month represents the number of months since the start of the dataset or period, enabling sequential month tracking. Formatted as an integer, e.g., 01.
Nth Week represents the number of weeks since the start of the dataset or period, offering sequential week tracking. Formatted as an integer, e.g., 01.