How do I calculated the number of days in a row the same value occurs? Daily streak?

Q&A
,
2

@hcorbett ,

Could you add an Arena example for the above ( QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community )

The first instance of Critical is 1. Then the Status is Warning (Streak = 1), but then it goes back to Critical and instead of starting over at 1 because the streak was broken, the value is 2.

I am not sure I completely understand the above.