I have members in a cluster which are supposed to be equally loaded in an ideal situation. I am trying to trigger an alert if an appliance load dips 30% by creating a table calculation variable “Variation” with type yesno:
round(((${display_95_percentile}/offset(${display_95_percentile},-1)) - 1)*100,0)<-30

I do get the data (circled red). But when i try to hide “No” from visualization, the two rows with “Yes” also disappears in the visual (this could be because of other appliances in those rows showing “No”).
Because of this I am unable to create an alert that should trigger only when one of the cols become Yes. Any help is much appreciated.