A practical guide to building period-to-date time series metrics (WTD, MTD, YTD, LYTD) using Sigma's InDateRange function on top of Snowflake data. Instead of writing complex SQL with CTEs and CASE statements, users can define custom Sigma functions once and reuse them across tables, charts, and pivot tables. The post covers
Table of contents
Instant WTD, MTD, YTD, LYTD etc period-to-date metrics for proactive decision makingGet Jeff Carpenter’s stories in your inboxSort: