PeriodEndSnapshot
Time intelligenceSemi-additive
PeriodEndSnapshot(expr, dateCol, grain)
LastNonEmpty applied within EACH period bucket: for every month (or week/quarter/…) the value at the last non-empty date inside it. The chart must group by the date column at the same grain (SQX010 otherwise) — the snapshot needs its buckets on the axis.
When to use it
Section titled “When to use it”- Balance trend lines: month-end stock by month, quarter-end pipeline by quarter.
- Any as of period close series where the last reading inside each bucket is the truth.
Example
Section titled “Example”EOMStock := PeriodEndSnapshot(Sum(Inventory.OnHand), Inventory.CountedAt, "month")Good to know
Section titled “Good to know”- The chart must group by the snapshot’s date column at the same grain — a month snapshot needs a month axis (SQX010 gate, not a silent wrong number).