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

Filter data based on formula value

akasubi
8 - Asteroid

Is it possible to filter data based on a value calculated from a formula?

 

Example, I've calculated the average value for one column using the summarise tool, and would like to filter this column for where values are higher than the calculated average. How do I do this?

 

Additionally, I have another formula which has been calculated from values from the summarise tool, can I filter the data based on the value of this formula as well?

 

Many thanks

afk

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @akasubi ,

 

the easiest way to do this is to append the calculated average to the fields and use the additional field in the filter tool. Of course you can modify the values in any way before using them to filter. I've attached a sample workflow. Hope this is helpful.

 

Best regards

 

Roland

akasubi
8 - Asteroid

Great, thank you Roland! This has done the trick 🙂

Labels