EVALUATE 'STREAK': COUNT OF LARGEST CONSECUTIVE ROW EQUAL VALUES
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Expression
- Fuzzy Match
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The multi row tool example will create Win Streak even if it doesn't exist, but your method works as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Interesting indeed! I didn't know that. Thx