Create Simple Query for Moving Average of Sales

Encerrado Postado Sep 22, 2015 Pago na entrega
Encerrado Pago na entrega

Create Simple Query for Moving Average of Sales

I have a table that has sales entries over time, with fields: customer_number, sales_amount, and process_date.

I want to look at

1) weekly sales amounts

2) and find the weekly moving average

3) and determine if the last 4 weeks of sales have dropped below 20% of the latest moving average

Output will be:

customer_number, sales_below_flag

with 1 row for each customer

Arquitetura de software Testes / Garantia de qualidade

ID do Projeto: #8531194

Sobre o projeto

4 propostas Projeto remoto Ativo em Nov 5, 2015

4 freelancers estão ofertando em média $55 nesse trabalho

esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile and portfolio. I am ready Mais

$166 USD in 5 dias
(22 Comentários)
7.0
Nomakram1

Respected Sir, Thank you for taking the time to read our initial posting. I have read initial project description and i am ready to start this project. For further details, please message in the pmb. Look forwar Mais

$13 USD in 0 dias
(0 Comentários)
0.0
prashant19785

A proposal has not yet been provided

$30 USD in 2 dias
(0 Comentários)
0.0