This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think I've got it. I've added a third Multi-Row Formula tool prior to the other two to count the records per Group (course_count) and made minor adjustments to the existing two Multi-Row Formula Tools.
Multi-Row Formula Tool 1: [Row-1:course_count]+1
Multi-Row Formula Tool 2: IF [course_count] = 1 then 0 ELSEIF [Row-1:ACTIVE_DAYS] = [ACTIVE_DAYS] THEN [Row-1:Ties]+1 ELSE 0 ENDIF
Multi-Row Formula Tool 3: IF [course_count] = 1 then [course_count] ELSEIF [Row-1:Ties]>0 AND [Row-1:ACTIVE_DAYS] != [ACTIVE_DAYS] THEN [Row-1:Rank]+1+[Row-1:Ties] ELSEIF [Row-1:ACTIVE_DAYS]=[ACTIVE_DAYS] THEN [Row-1:Rank] ELSE [Row-1:Rank]+1 ENDIF
Add a formula tool Change the value of the current field for Ranking: Ranking + 1
If you haven't used the Formula tool...
Beginning users can find some great information on the Alteryx web site under Community > Academy.
Try Learning Paths Try Interactive Lessons Under the link for Videos, click the pinned post for Video Training Index, and look at the videos with Difficulty = Beginner Under Weekly Challenge, click the pinned post for Weekly Challenge Index & Welcome, and try the challenges with Level of Difficulty = Beginner