source  temperature timestamp
1001    21  4/28/2019 10:25
1001    22  4/28/2019 10:26
1001    23  4/28/2019 10:27
1001    24  4/28/2019 10:28
1001    25  4/28/2019 10:29
1001    34  4/28/2019 10:30
1001    37  4/28/2019 10:31
1001    36  4/28/2019 10:32
1001    38  4/28/2019 10:33
1001    40  4/28/2019 10:34
1001    41  4/28/2019 10:35
1001    42  4/28/2019 10:36
1001    45  4/28/2019 10:37
1001    47  4/28/2019 10:38
1001    50  4/28/2019 10:39
1001    41  4/28/2019 10:40
1001    42  4/28/2019 10:41
1001    45  4/28/2019 10:42
1001    47  4/28/2019 10:43
1001    50  4/28/2019 10:44

Transform
source  range   count   alert
1001    21-25   5   HIGH
1001    26-30   5   MEDIUM
1001    40-45   5   MEDIUM
1001    45-50   5   HIGH