In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Make Alteryx seek a specific average

RasmusTS
6 - Meteoroid

Hi everyone 

 

I'm currently making a workflow, where based on a sample, the workflow should seek to remove rows so that the average will become XX.

 

To clarify, I have a large dataset and I only want to keep rows so that the total average is equal to, fx 150. 

Meaning that every row which does not conform with this, should be removed, ie: if I have 4 rows: 

250
200
150
100

 

I would want the workflow to filter out the row with 250.

 

Does anybody have any experience in this regard?

 

Thank you in advance!

 

3 REPLIES 3
BRRLL99
11 - Bolide

Please let if this is your output

I have taken avg from 4 rows and matched it with each row and then filtered only greater than rows

 

BRRLL99_0-1687339344309.png

 

hlee36
8 - Asteroid

I'm confused. 

 

If you have rows of 250, 200, 150 and 100 and filter out 200, you will have the average of 166.67 ((250+150+100)/3). But, you said the average should be 150.

 

Shouldn't you filter out 250 so that the average will be 150 ((200+150+100)/3)? 

 

Correct me if I'm wrong. Please clarify so I can attempt to solve this.

RasmusTS
6 - Meteoroid

That is what I meant. I'm sorry for the confusion/error.

Labels
Top Solution Authors