Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

HomesickSurfer
12 - Quasar

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 TEAMSTREAK
A3
B4
4 REPLIES 4
BrandonB
Alteryx
Alteryx

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

 

BrandonB_0-1634320989646.png

 

BrandonB_1-1634321034615.png

 

 

HomesickSurfer
12 - Quasar

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
Alteryx
Alteryx

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

HomesickSurfer
12 - Quasar

Interesting indeed!  I didn't know that.  Thx

Labels