How to find consecutive 3 days and 2 days particular customer is red

Hi Team,

I need to find consecutive 3 days and 2 days for a particular customer if it red for any of the 3 metrics. Once I filter 2 days it should filter 2 days and if 2 days it should filter 3 days.

Where there is not data in any metric tag as blank.