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

Desired output:

WINNING TEAM	STREAK
A	3
B	4

Macros

Fuzzy Match

Expression

Accepted answers

BrandonB

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

All comments

BrandonB

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280