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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am trying to replicate an excel count if formula. The difference with this is I want to count all items down a list, but nothing above. See below attachment for illustration
In this example, the count on 2135658HFA is 3 (in total). but by the second one, the count excludes the one above. so there are only 2 to count. Then on the last it becomes 1, as it excludes the 2 above.
Essentially, i want to allocate a "1" next to the LAST unique concat 2.