I want to find the max of is_stale_or_missing per pipeline and then aggregate that per service. I am not sure if it is even possible to do both of these things simultaneously. I tried but could not find a way to do it.
I would really appreciate some guidance on this. For reference, I have attached a screenshot.