Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Create and fill dependent growth columns

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

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