Alteryx designer Discussions

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

Create and fill dependent growth columns

Highlighted
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 :))

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@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