Hi! I'm not sure if this is the right place for this, but I'm a new Alteryx user trying to use it to determine the current owner tasks. I've included an example below with some dummy data and the my desired result, but I'm struggling with the best approach. When the initial data is generated, each task become several lines with information regarding each task assignment (ex. line 1: Task 1, Prep, 100%; line 2: Task 1, Reviewer, 0%). Ultimately, I'd like Alteryx to determine the lowest person in the assignment chain who has 0%.
I've tried using the formula tool and "if and" functions, but I'm not sure how to tackle the duplicative task/multiple row portion. Is there an efficient way to get this that I'm missing?
