Please see my dataset attached.
The summary tab is the computed averages for checking purpose.
Please also check the application attached. I am able to achieve the line chart by location, by month, by year.
However, I also need to have a line chart that is presenting moving averages, like every one point is a total average of a selected period (e.g. 6 months: Sept 14 - Feb 15, Oct 14 - Mar 15, Nov 14 - Apr 15, Dec 14 - May 15 ...)
Feel free to contact me if you are unclear about the requirement.
test data.zip 463.4 K