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
Solved! Go to 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
Great, thank you Roland! This has done the trick 🙂