Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Grouping data, repeating formula on each and combining output

Ebenvnie
5 - Atom

Hi,

 

Hoping I can get my question explained! I would like to 

1) Group data

2) Run same formula on all groups (with only building it once and having various inputs {based on grouped data})

3) Combine findings in 1 output

 

As an example: 

Group                    Value            Time

a                              3                   10

b                              5                    8

a                              8                    9

a                              9                    12

b                             11                   11

c                              7                     12

 

Wanted: Group (auto allocate the groups based on info contained), median of values, top quartile of time, add column "outcome" with median x top quartile

 

Outcome:

Group           Median   Top Quartile    Outcome

a                      ....                ....                 ...

b                      ....                ....                 ...

c                     .....                 ...                  ...

 

 

2 REPLIES 2
chris_love
12 - Quasar

Some pointers, I'll let you investigate and then post a fuller answer if the pointers don't help:

 

  • I would suggest using a Summarise Tool to Group the data and calculate the median and quartile (percentile at 75%)

 

  • Then using a formula tool to calculate your latter Outcome column

 

Have fun,

 

Chris

Ebenvnie
5 - Atom

Thanks Chris for the reply. It's amazing just thinking about it simpler...

 

I did a very simple example (in contrast to the really complicated file I'm nusy with), but your suggestion also made me apply a simple solution rather than the complicated one I had previously with multiple filters....

 

Thanks

 

Labels