Sensor Uptime & Data Completeness %
This lesson is part of the course
In this lesson
You count received and valid readings for four sensors, compute data completeness and compare it with the uptime from the gateway log.
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