Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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