For each name, I want to find all the amounts that deviates more than or equal to 20% from their avg. In the example above, I want to see the amount 200 and 100 because that deviates more than 20% of their avg, which is 150.
How can I create a data table with these constraints?
Hi @tamjid
I'm sorry for the very late reply, was you able to solve the issue by your own?
If so, it will be great if you can post the solution there, if not I'm more then happy to help you on this
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.