ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQ's.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Create and fill dependent growth columns

ArminL
7 - Meteor

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)

 

ArtistMonthUnits SoldAbs. growthRel. growth

Pink

150  
Pink2752550%
Pink310025 
Eminem160  
Eminem28020 
Eminem310020 
U2125  
U227550 
U2310025 

 

Thanks in advance :))

MarqueeCrew
19 - Altair
19 - Altair

@ArminL,

 

You will use 2 Multi-Row formula tools. 

 

  1. Abs Growth:
    1. Group by Artist
  2. [Units Sold]-[Row-1:Units Sold]
    Rel Growth:
    1. Group by Artist
      IF [Row-1:Units Sold]> 0 THEN 
      [Abs Growth]/[Row-1:Units Sold]
      ELSE 0
      ENDIF
      Note:  I used this conditional logic to avoid division by 0

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels