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.
So I have a question. I have a column in alteryx named "ID User" and another column named "Year." Illustrated below:
ID USER YEAR
What I am trying to do in Alteryx is that I want to know if ID "53" from the "ID USER" column, came back to the organization Year-Over-Year; like if he came 2016 and 2017 to get a "1" as a result, and if NOT (which is the case of ID "61"), to be a "0". ID "61" would not count because he came back but until 2018 not 2017.
I added another entry just to illustrate the point further. You're going to want a multi-row formula to look at the next year of every entry if the year is 1 greater than the current then this means they attended year over year at least once.