Now by using Scripted Field i want to calculate Average Value whose formula is
Average Value = (Sum of Revenue / Unique Count of Orders) for a given Month
Average Value for Jan = 280/2 = 140
Average Value for Feb=310/3= 103
There really isn't any way to get this information via scripted fields, but you can do this with the "Average Bucket" metric.
If you set it up like in the screenshot it will split the bucket the data by order, sum up the revenue for each bucket, and then take an average of those sums, getting the same value you described.
If you combine that with a "Split rows" bucket on month, you can get a visualization showing what you asked for:
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.