From a mysql table orders_history, calculate the weekly moving average. I would also like be able to calculate a 4 week and a 12 week moving average.
Use mysql to calculate.
I have simple table called orders_hjstory that contains sales transactional data.
Want previous experience in similar project.
Will provide sample table schema and data on request.
The current data i have contains over 1million rows so the query needs to be optimised.
I have successfully written a query to give me the weekly average, now I would like the moving average
29 freelancere byder i gennemsnit $143 på dette job
hi, Ready to start right now. I can provide quality and standard work. Experienced in MySQL and using aggregate functions. Please PM me for more details. Thank you
Hi, i am expert developer, i would like to make this query. Thanks Relevant Skills and Experience Big Data, MySQL, Software Architecture Proposed Milestones $222 AUD - Default
Give the weekly, 4 week, and 12 week moving averages Relevant Skills and Experience Am quite experienced with MySQL Proposed Milestones $30 AUD - Get averages needed