Threshold breached on consecutive days

I am trying to put together a report that will show locations where a certain KPI was breached on three or more consecutive days in the last 30 days. Does looker support such calculation?