For the following data,
Date=4 June 2013, Result=Win,Ticks=11,Setup=Range Fade, Risk=10, Target=11
.....and more
I would like to find the average for the Risk and Target fields each and to remove the decimal places. I have written the following query:
source="Trading Stats.txt" | search Risk | search Target | stats avg(Risk) as average_risk avg(Target) as average_target
which can display the average of each of the Risk and Target fields but I am unable to get the round function to work.
In addition, I would also like to show the data on a bar chart with the average value of the Risk field as 1 bar and the average value of the Target field as the second bar on the same chart.
How do I do so?
Thanks
... View more