Articles in this section

Atlas Charts Date Ranges

Atlas is our historical reporting system, and shows only complete day data ensure data integrity and consistency. This means that current day can only be seen through live displays or the API, not Atlas charts. This exclusion prevents incomplete or partial data from affecting analytics calculations.

Current day data is excluded from all date ranges because:

  • Building occupancy data for "today" is not guaranteed to be complete
  • Including partial day data skews analytics and comparisons
  • Historical analysis requires complete, closed time periods

Two Types of Date Periods

1. Calendar Periods (Complete Time Blocks)

These represent complete, naturally-bounded calendar periods:

  • "Last Week" - Complete Sunday-to-Saturday week
  • "Last Month" - Complete calendar month (e.g., May 1-31)
  • "Last 3 Weeks" - Last three complete Sunday-to-Saturday weeks

2. Rolling Periods (Lookback Windows)

These represent fixed-duration lookbacks from a reference point:

  • "Last 7 Days" - 7-day window ending yesterday
  • "Last 30 Days" - 30-day window ending yesterday
  • "Last 90 Days" - 90-day window ending yesterday

Examples (assuming today is June 4, 2025)

Calendar Periods

  • "Last Week": May 25 - May 31 (complete Sunday-Saturday week)
  • "Last Month": May 1 - May 31 (complete May)

Rolling Periods

  • "Last 7 Days": May 28 - June 3 (7 complete days ending yesterday)
  • "Last 30 Days": May 5 - June 3 (30 complete days ending yesterday)

Key Distinction

  • Calendar: "Give me the last complete month" → May 1-31
  • Rolling: "Give me the last 30 days of complete data" → May 5 - June 3

This ensures all analytics operate on complete, consistent datasets while providing intuitive date range behavior for both calendar-based and duration-based analysis needs.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.