How are null and missing treated by the platform?

#1

Case 1:
myMetric:
Data = [0,1,2]
Missing = [100,0,0]

window(‘MIN’, missing(myMetric) > 90 ? null : myMetric, -3, 0)

What is my minimum of [null, 1, 2]?

Case 2:
myMetric:
Data = [0,1,2]
Missing = [50,0,0]

window(‘MIN’, myMetric, -3, 0)

If 50% is missing, will my first datapoint of my metric be 0 or null? If it’s 0, the minimum is obviously 0. If it’s null, the question goes back up to Case 1.

0 Likes