blob: dc35cd95697efd2baa15687f46990958e1e8b0b0 [file] [log] [blame]
-- This file is automatically generated. You should know what you did if you want to edit this
-- !select_data --
2024-01-01T10:00 temperature 20.5 sensor1 room1
2024-01-01T10:00 humidity 45 sensor2 room1
2024-01-01T10:00 temperature 19.5 sensor3 room2
2024-01-01T10:05 temperature 21 sensor1 room1
2024-01-01T10:05 humidity 46 sensor2 room1
2024-01-01T10:05 temperature 20 sensor3 room2
2024-01-01T10:10 temperature 21.5 sensor1 room1
2024-01-01T10:10 humidity 47.5 sensor2 room1
2024-01-01T10:10 temperature 20.8 sensor3 room2
2024-01-01T10:15 temperature 22 sensor1 room1
2024-01-01T10:15 humidity 48 sensor2 room1
2024-01-01T10:15 temperature 21.2 sensor3 room2
2024-01-01T10:20 temperature 22.5 sensor1 room1
2024-01-01T10:20 humidity 49 sensor2 room1
2024-01-01T10:20 temperature 21.8 sensor3 room2
-- !moving_avg_3period --
2024-01-01T10:00 sensor1 20.5 20.5
2024-01-01T10:05 sensor1 21 20.75
2024-01-01T10:10 sensor1 21.5 21
2024-01-01T10:15 sensor1 22 21.5
2024-01-01T10:20 sensor1 22.5 22
2024-01-01T10:00 sensor3 19.5 19.5
2024-01-01T10:05 sensor3 20 19.75
2024-01-01T10:10 sensor3 20.8 20.1
2024-01-01T10:15 sensor3 21.2 20.66666666666667
2024-01-01T10:20 sensor3 21.8 21.26666666666667
-- !rolling_stddev --
2024-01-01T10:00 sensor1 20.5 \N
2024-01-01T10:05 sensor1 21 0.25
2024-01-01T10:10 sensor1 21.5 0.408248290463863
2024-01-01T10:15 sensor1 22 0.5590169943749475
2024-01-01T10:20 sensor1 22.5 0.5590169943749475
2024-01-01T10:00 sensor3 19.5 \N
2024-01-01T10:05 sensor3 20 0.25
2024-01-01T10:10 sensor3 20.8 0.535412613473634
2024-01-01T10:15 sensor3 21.2 0.6647367900154164
2024-01-01T10:20 sensor3 21.8 0.6538348415311012
-- !change_from_first --
2024-01-01T10:00 sensor1 20.5 20.5
2024-01-01T10:05 sensor1 21 20.75
2024-01-01T10:10 sensor1 21.5 21
2024-01-01T10:15 sensor1 22 21.5
2024-01-01T10:20 sensor1 22.5 22
2024-01-01T10:00 sensor3 19.5 19.5
2024-01-01T10:05 sensor3 20 19.75
2024-01-01T10:10 sensor3 20.8 20.1
2024-01-01T10:15 sensor3 21.2 20.66666666666667
2024-01-01T10:20 sensor3 21.8 21.26666666666667
-- !minmax_normalize --
sensor1 2024-01-01T10:00 20.5 20.5 20.5
sensor1 2024-01-01T10:05 21 20.5 21
sensor1 2024-01-01T10:10 21.5 20.5 21.5
sensor1 2024-01-01T10:15 22 20.5 22
sensor1 2024-01-01T10:20 22.5 20.5 22.5
sensor3 2024-01-01T10:00 19.5 19.5 19.5
sensor3 2024-01-01T10:05 20 19.5 20
sensor3 2024-01-01T10:10 20.8 19.5 20.8
sensor3 2024-01-01T10:15 21.2 19.5 21.2
sensor3 2024-01-01T10:20 21.8 19.5 21.8
-- !cumulative_weighted --
2024-01-01T10:00 room1 humidity 45 45 45
2024-01-01T10:05 room1 humidity 46 45.5 45.5
2024-01-01T10:10 room1 humidity 47.5 46.16666666666666 46.75
2024-01-01T10:15 room1 humidity 48 46.625 47.75
2024-01-01T10:20 room1 humidity 49 47.1 48.5
2024-01-01T10:00 room1 temperature 20.5 20.5 20.5
2024-01-01T10:05 room1 temperature 21 20.75 20.75
2024-01-01T10:10 room1 temperature 21.5 21 21.25
2024-01-01T10:15 room1 temperature 22 21.25 21.75
2024-01-01T10:20 room1 temperature 22.5 21.5 22.25
2024-01-01T10:00 room2 temperature 19.5 19.5 19.5
2024-01-01T10:05 room2 temperature 20 19.75 19.75
2024-01-01T10:10 room2 temperature 20.8 20.1 20.4
2024-01-01T10:15 room2 temperature 21.2 20.375 21
2024-01-01T10:20 room2 temperature 21.8 20.66 21.5
-- !trend_detection --
2024-01-01T10:00 sensor1 20.5 20.5 Below MA
2024-01-01T10:05 sensor1 21 20.75 Above MA
2024-01-01T10:10 sensor1 21.5 21 Above MA
2024-01-01T10:15 sensor1 22 21.5 Above MA
2024-01-01T10:20 sensor1 22.5 22 Above MA
2024-01-01T10:00 sensor3 19.5 19.5 Below MA
2024-01-01T10:05 sensor3 20 19.75 Above MA
2024-01-01T10:10 sensor3 20.8 20.1 Above MA
2024-01-01T10:15 sensor3 21.2 20.66666666666667 Above MA
2024-01-01T10:20 sensor3 21.8 21.26666666666667 Above MA
-- !multi_metric --
2024-01-01T10:00 room1 20.5 45 20.5 45
2024-01-01T10:05 room1 21 46 20.75 45.5
2024-01-01T10:10 room1 21.5 47.5 21 46.16666666666666
2024-01-01T10:15 room1 22 48 21.5 47.16666666666666
2024-01-01T10:20 room1 22.5 49 22 48.16666666666666
2024-01-01T10:00 room2 19.5 \N 19.5 \N
2024-01-01T10:05 room2 20 \N 19.75 \N
2024-01-01T10:10 room2 20.8 \N 20.1 \N
2024-01-01T10:15 room2 21.2 \N 20.66666666666667 \N
2024-01-01T10:20 room2 21.8 \N 21.26666666666667 \N
-- !gap_analysis --
A 2024-01-01T10:00 10 10
A 2024-01-01T10:05 11 11
A 2024-01-01T10:10 12 12
A 2024-01-01T10:20 15 15
A 2024-01-01T10:25 16 16
B 2024-01-01T10:00 20 20
B 2024-01-01T10:10 22 22
B 2024-01-01T10:15 23 23
-- !window_percentile --
room1 2024-01-01T10:00 20.5 20.5
room1 2024-01-01T10:05 21 20.75
room1 2024-01-01T10:10 21.5 21
room1 2024-01-01T10:15 22 21.5
room1 2024-01-01T10:20 22.5 22
room2 2024-01-01T10:00 19.5 19.5
room2 2024-01-01T10:05 20 19.75
room2 2024-01-01T10:10 20.8 20
room2 2024-01-01T10:15 21.2 20.8
room2 2024-01-01T10:20 21.8 21.2
-- !cumulative_dist --
sensor1 20.5 20.5 1
sensor1 21 20.75 2
sensor1 21.5 21 3
sensor1 22 21.25 4
sensor1 22.5 21.5 5
sensor3 19.5 19.5 1
sensor3 20 19.75 2
sensor3 20.8 20.1 3
sensor3 21.2 20.375 4
sensor3 21.8 20.66 5
-- !module_reuse --
sensor1 21.5 21.5
sensor3 20.66 20.66
-- !combined_analytics --
2024-01-01T10:00 sensor1 20.5 20.5 \N 20.5 20.5
2024-01-01T10:05 sensor1 21 20.75 0.25 20.5 21
2024-01-01T10:10 sensor1 21.5 21 0.408248290463863 20.5 21.5
2024-01-01T10:15 sensor1 22 21.5 0.408248290463863 21 22
2024-01-01T10:20 sensor1 22.5 22 0.408248290463863 21.5 22.5
2024-01-01T10:00 sensor3 19.5 19.5 \N 19.5 19.5
2024-01-01T10:05 sensor3 20 19.75 0.25 19.5 20
2024-01-01T10:10 sensor3 20.8 20.1 0.535412613473634 19.5 20.8
2024-01-01T10:15 sensor3 21.2 20.66666666666667 0.4988876515698587 20 21.2
2024-01-01T10:20 sensor3 21.8 21.26666666666667 0.4109609335312652 20.8 21.8