Average of values that are no more 10% apart from each other

[miguelpdv]

Hello to all, sorry if this is a newbie question, but I'm just entering into the Alteryx world.

I need to calculate the "Filtered average" from five values, according to the following conditions:

• Values that are more than 10% apart the from others shall not be averaged.
• Nulls must be ingnored
• Values outside a range must be ignored, for example average values only if 0<Averaged value<100
• A quality index is desirable, where 5 values were used to calculate the average the quality is 5 and a quality of 0 would be assigned when no values met the criteria (no values were used for the average).

To better illustrate the problem, here are some examples:

The problem would be relatively easy to solve using formulas and temporay variables, however as far as I can see, there is no way to use temporary variables into a formula. Maybe there is a very simple way to solve this with Alteryx but I'm failing to see it.

Thank you for your help.

[Qiu · Accepted solution]

@miguelpdv 
Hope this is what you what. Use the Median to get the "middle" value in the list of value.

Appreciate if you would mark it as accepted if you think this works for you.

[miguelpdv]

Well, that was quick! Many thanks Qiu!.

I will struggle a bit to fully understand the solution but clearly the results are correct.

Thank you for showing me that this is a great and helpful community.

[Qiu]

@miguelpdv 
Thank you for the mark also.

Have a good day!