Make Alteryx seek a specific average

Question

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:

250200150100

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

Does anybody have any experience in this regard?

Thank you in advance!

RasmusTS · Answer

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

hlee36 · Answer

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.

BRRLL99 · Answer

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