Resampling to Hourly Averages with HOUR & AVERAGEIFS
This lesson is part of the course
In this lesson
You put 15-minute readings into hourly buckets and compute readings per hour, hourly mean and hourly maximum, the way dashboards downsample sensor data.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Timestamps & Sampling Intervals: Finding the Gaps Locked
- Resampling to Hourly Averages with HOUR & AVERAGEIFS Locked
- Threshold Excursions: Count, Minutes & the Longest Excursion Locked
- Sensor Uptime & Data Completeness % Locked
- Calibration Drift vs a Reference Sensor: SLOPE & FORECAST Locked
- Smoothing: Moving Average vs Raw Noise (with a Chart) Locked
- Alert Rules with Hysteresis: ON above X, OFF below Y Locked
- Compliance Report: Daily Status, Time in Range, MKT & a Chart Locked