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've done a lot of searching on countif solutions and can't seem to find one that works for my situation.
I have data set that ranks about 150 people on ytd performance on a particular metric. I have a field that adds a scenario for the following week and calculates their ytd value based on if this scenario happens.
I need to be able to rank the new ytd value based on the actual ytd value from the current week. It's a way to see how their ranking would change next week holding everyone else constant.
In excel it's a simple countif formula, but I really need to be able to do this in Alteryx if I can.