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.
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!
Hey everybody,
can someone help me how I could create and automatically fill the columns "Abs. growth" and "Rel. growth" in alteryx.
Only the first three columns are available from my database...
As their is no regularity, I especially don't know how to calculate these new columns fitted to the specific artist. (e.g. i do not want to get a rel growth from 1 month from eminem to 3rd month of Pink)
Artist | Month | Units Sold | Abs. growth | Rel. growth |
Pink | 1 | 50 | ||
Pink | 2 | 75 | 25 | 50% |
Pink | 3 | 100 | 25 | |
Eminem | 1 | 60 | ||
Eminem | 2 | 80 | 20 | |
Eminem | 3 | 100 | 20 | |
U2 | 1 | 25 | ||
U2 | 2 | 75 | 50 | |
U2 | 3 | 100 | 25 |
Thanks in advance :))
Solved! Go to Solution.
You will use 2 Multi-Row formula tools.
[Units Sold]-[Row-1:Units Sold]Rel Growth:
IF [Row-1:Units Sold]> 0 THEN [Abs Growth]/[Row-1:Units Sold] ELSE 0 ENDIFNote: I used this conditional logic to avoid division by 0
Cheers,
Mark