Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
SPOILER
Posting a potential solution to this use case.
The original requirements were asking if a unique UserID has any likelihood of visiting other stores, which would beg the question of which UserIDs were visiting two or more merchant. As such, I have filtered out instances where the Merchant1 field were null because this would be irrelevant to answering the original business question, unless we were examining two distinct populations: 1) those who only visit a singular merchant, and 2) those who visit two or more merchants.
Attaching workflow and diagram to help explain the steps I took. Hopefully it helps!
Posting a potential solution to this use case.
The original requirements were asking if a unique UserID has any likelihood of visiting other stores, which would beg the question of which UserIDs were visiting two or more merchant. As such, I have filtered out instances where the Merchant1 field were null because this would be irrelevant to answering the original business question, unless we were examining two distinct populations: 1) those who only visit a singular merchant, and 2) those who visit two or more merchants.
Attaching workflow and diagram to help explain the steps I took. Hopefully it helps!
