TotalDays / Temporal Layer

Convert duration values to total number of days, similar to timedelta.total_days() or DATEDIFF(). Returns integer count of complete days.

Duration conversion examples:

Duration	Total Days	Note
48:00:00	2	Exactly 2 days
25:00:00	1	1 day + 1 hour
72:30:00	3	3 days + 30 minutes

Common applications:

Service duration calculation
Billing periods
Project timeframes
SLA monitoring Note: Partial days are truncated, not rounded.

Table

Transforms

[, ...]

Select

column

Duration column to convert to days. Input must be a duration type. Converts all time units to complete days, discarding any remainder.

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.