Create Simple Query for Moving Average of Sales
Encerrado
Postado
Sep 22, 2015
Pago na entrega
$10-30 USD
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
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
$30 USD in 2 dias
(0 Comentários)
0.0