Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
im trying to run the script below but an error legend appear which saids
"Field not found - <AñoMes>
AsOf:
Load distinct AñoMes
Resident CALENDARIO_SUBSCRIPTIONS"
"Table not found
Left Join (AsOf)
Load AñoMes as AñoMesAsOf
Resident AsOf"
Inner Join (AsOf)
Load *
Resident AsOf
Where AñoMesAsOf >= AñoMes"
1) Script:
CALENDARIO_SUBSCRIPTIONS:
LOAD
Year(PeriodDate) & Num(Month(PeriodDate),'00') & Num(Day(PeriodDate),'00') as %Key_MODIFIED_SUBSCRIPTIONS,
Year(PeriodDate) as Año,
Month(PeriodDate) as Mes,
Day(PeriodDate) as Dia,
PeriodDate as Fecha,
DUAL(Month(PeriodDate) & '-' & Year(PeriodDate),
Year(PeriodDate) & Num(Month(PeriodDate),'00')) as AñoMes,
Week(PeriodDate) as Semana,
Ceil(Month(PeriodDate)/3) as Trimestre,
(Year(PeriodDate) * 12) + Num(Month(PeriodDate)) as LineaTemporal
RESIDENT TempCalendar;
Resident CALENDARIO_SUBSCRIPTIONS;
Resident AsOf;
Where AñoMesAsOf >= AñoMes;
thanks!
gerardo
great! thank you very much to both!
Hi Marcos and Swuehl,
i tried a lot of times to do the same with only subscriptions but i couldn't, i mean the full accumulation expression of
Count(DISTINCT SUBSCRIPTIONS.email) with out full accumulation expresion box enable....
could you please give me some advice?
Thanks
Maybe something like
=aggr( rangesum( above(
Count({<CALENDARIO_SUBSCRIPTIONS.AñoMes=, SUBSCRIPTIONS.is_subscribed={0,1}>} DISTINCT SUBSCRIPTIONS.email)
,0,rowno()))
, CALENDARIO_SUBSCRIPTIONS.AñoMes)
sorry....that give me the values of each month and not the accumulation....
some other idea?
Seems to work for me:
and if I select last few month:
now is working.....thanks you!
