Filter data based on formula value

[akasubi]

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

[RolandSchubert · Accepted solution]

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]

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