EVALUATE 'STREAK': COUNT OF LARGEST CONSECUTIVE ROW EQUAL VALUES

[HomesickSurfer]

countHi

Perhaps easier than i think...but I cannot figure it out.

I'd like to know how to generate a summary of each team's win streak.

ie:  how many times have they won consecutively?

I'd appreciate any guidance or solution offered.  Thank you.

WINNING TEAM

A

B

B

A

A

A

B

B

B

B

Desired output:

WINNING TEAM	STREAK
A	3
B	4

[BrandonB · Accepted solution]

You can do this with a multi row tool that calculates the win streak and then a summarize tool that groups by winning team and then takes the max of the win streak column

[HomesickSurfer]

Thank you very much @BrandonB !

Works perfectly and efficiently!!!

Note:  As it didn't exist in my source data, I had to create the [Win Streak] variable, with expression: 1, Data type: Int16, Size:2

[BrandonB]

The multi row tool example will create Win Streak even if it doesn't exist, but your method works as well. 

[HomesickSurfer]

Interesting indeed!  I didn't know that.  Thx