topic Re: Average field in the script - Campo promedio en el script in Connectivity & Data Prep

Average field in the script - Campo promedio en el script

Wed, 03 Aug 2016 15:24:15 GMT

hi everyone, i am using qliksense, i have a table with exchanges rates per day, i need calculated a average the rates per month, the table is.

daily_ER:

load

exchnage_rates

currency_code

currency

exch_date // this field have the information day per day, i need a fiel with the average per month.

from.......xxxxxxxxx

----------------------

hola a todos tengo una tabla con tipos de cambio por dia, necesito calcular un promedio de tipos de cambio por mes, la tabla es

diario_tc

load

tipos_de_cambio

codigo_moneda

moneda

fecha_de_tc // este camo tiene la informacion dia por dia, yo necesito un campo que tenga promedio por mes

from...... xxxxxxxx

thanks

sunny_talwar — Wed, 03 Aug 2016 16:13:26 GMT

May be like this:

daily_ER:

LOAD exchnage_rates,

currency_code,

currency,

exch_date,

MonthName(exch_date) as MonthYear

from.......xxxxxxxxx

Left Join(daily_ER)

LOAD MonthYear,

currency_code,

currency,

Avg(exchnage_rates) as Monthly_AverageRate

Resident daily_ER

Group By MonthYear, currency_code, currency;

Wed, 03 Aug 2016 16:42:44 GMT

thank you, so much, i really appreciate your help!