⛏️GetSplunky!
Lv.1Intern
0 XP
0
Home Map Stats Drill Board Log In
CoursesArticlesSPL Cheat SheetCertification PathAboutPrivacyTerms

Splunky is an independent, free study resource. It is not affiliated with, endorsed by, or sponsored by Splunk or Cisco. Splunk, SPL and related marks are trademarks of Splunk, a Cisco company, and are used here only to identify the certifications this site helps you study for.

© 2026 Splunky

Back to Floor
Analytics Crucible • Room 2

Calendar Windows, EWMA & Rate of Change

SignalFlow supports two fundamentally different ways to aggregate across time: moving (sliding) windows and calendar windows.

A moving window like .sum(over='1d') slides continuously—at 14:30, it covers yesterday 14:30 to today 14:30. By contrast, a calendar window resets cleanly on fixed boundary ticks (hour, day, week, month) aligned to a chosen timezone (such as America/New_York or UTC) configured in Chart/Detector options or the SignalFlow Execute API (timezone is not passed to .sum()). Calendar windows answer business questions like "total orders since midnight today" or "monthly SLA error budget consumed so far".

For smoothing and trend velocity, SignalFlow also offers Exponentially Weighted Moving Averages (.ewma(over='5m') or .ewma(rho=0.2))—which weights recent datapoints more heavily than older ones—along with .delta() and .rateofchange() to measure how rapidly a gauge or counter is climbing or falling.

Moving Window vs. Calendar Window
# Moving 24h window (rolling)
rolling_24h = data('orders.total', rollup='sum').sum(over='1d')

# Calendar day window (resets at midnight; cycle_start takes an hourly offset like '00h' or '08h')
# Note: timezone (e.g., 'UTC') is a Chart/Detector/API execution setting, not a .sum() parameter
cal_today = data('orders.total', rollup='sum').sum(cycle='day', cycle_start='00h')
Choose a calendar window when stakeholders expect totals to reset at midnight or Monday 00:00; choose a moving window (over=) for continuous operational alerting.

Knowledge Check

Prove your understanding to clear the room (Rewards XP)
❤️❤️❤️
Question 1 of 2
A product manager asks for a Single Value chart showing total API billing units consumed since midnight Eastern Time today, resetting cleanly to zero every midnight. Which analytics approach should you use?
AA calendar window set to day aligned to America/New_York
BA rolling window using .sum(over='24h') across hosts
CA .timeshift('1d') comparison without a time window
DChanging the chart resolution from 1 minute to 1s