crit: (r) => r.server_1 >= 90.0 and r.server_2 >=90
Let me know if that helps!
PS the utility of pivoting your data is described in this section (fieldsAsCol() function is usually used instead of pivot). This resource might be helpful to you:
Hello @Anaisdg!
Sorry for my late answer… Unfortunately, it isn’t the unified solution. Because I will need to add each server. Also, server_1 may be less than 90 and server_2 not.
So, I don’t see another way, only create separate checks. However, thanks for your help!
@Anaisdg Hey! I found solution with a little trick
I just removed _measurement and renamed server to _measurement. And then created message by _source_measurement