Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A_Call:
LOAD Calls.CountryCode & Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM') & SKILL_NUMBER & Calls.isNonClaim as %Call,
Calls.CountryCode,
Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM') as Calls.Date,
SKILL_NUMBER,
ApplyMap('MapCallSkillNoToName', SKILL_NUMBER) as SKILL_NAME,
Calls.isNonClaim,
ASA,
sum(CALLS_RECEIVED) as CALLS_RECEIVED,
sum(CALLS_ANSWERED) as CALLS_ANSWERED,
sum(CALLS_ABANDONED) as CALLS_ABANDONED,
sum(CALLS_TRANSFERRED) as CALLS_TRANSFERRED,
//avg(ASA) as ASA,
sum(ASA) as SumASA,
max(MAXIMUM_ANSWER_DELAY) as MAXIMUM_ANSWER_DELAY,
sum(CUST_ABANDONED) as CUST_ABANDONED,
sum(CALLS_ANSWERED_WITHIN_SLA) as CALLS_ANSWERED_WITHIN_SLA,
sum(CUST_OFFERED) as CUST_OFFERED//,
FROM
[..\QVDs\T_Call.qvd]
(qvd)
group by Calls.CountryCode, Calls.Date, SKILL_NUMBER, Calls.isNonClaim, ASA
where Year( Calls.Date ) > '2014';
I was using
If(Year(Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM')) >= 2014, Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM')) as Calls.Date,
within the app but then, Calls.Date will still have pre-2014 data and I don't want this.
I am guessing the Where clause can ONLY bring in 2014 and post 2014 data.
Any ideas on how to get this Where clause to work? What I currently have doesn't work
write Where clause before Group by
Doesn't like my Where clause no matter what I write.
I've tried
Where Calls.Date >= '28/12/2013'
or
Where Years(Date) >= '2014'
and doesn't like whatever I put in.
Try
A_Call:
LOAD Calls.CountryCode & Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM') & SKILL_NUMBER & Calls.isNonClaim as %Call,
Calls.CountryCode,
Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM') as Calls.Date,
SKILL_NUMBER,
ApplyMap('MapCallSkillNoToName', SKILL_NUMBER) as SKILL_NAME,
Calls.isNonClaim,
ASA,
sum(CALLS_RECEIVED) as CALLS_RECEIVED,
sum(CALLS_ANSWERED) as CALLS_ANSWERED,
sum(CALLS_ABANDONED) as CALLS_ABANDONED,
sum(CALLS_TRANSFERRED) as CALLS_TRANSFERRED,
//avg(ASA) as ASA,
sum(ASA) as SumASA,
max(MAXIMUM_ANSWER_DELAY) as MAXIMUM_ANSWER_DELAY,
sum(CUST_ABANDONED) as CUST_ABANDONED,
sum(CALLS_ANSWERED_WITHIN_SLA) as CALLS_ANSWERED_WITHIN_SLA,
sum(CUST_OFFERED) as CUST_OFFERED//,
FROM
[..\QVDs\T_Call.qvd]
(qvd)
where Year( Calls.Date ) > '2014'
group by (Calls.CountryCode & Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM') & SKILL_NUMBER & Calls.isNonClaim),
Calls.CountryCode, Date(Date#(Calls.Date, 'DD/MM/YYYY'), 'YYYYMM'),
ApplyMap('MapCallSkillNoToName', SKILL_NUMBER), Calls.isNonClaim, ASA
Have you tried the following?
Where Year(Calls.Date) >= 2014
..............
FROM [..\QVDs\T_Call.qvd] (qvd)
where Year( Calls.Date ) > 2014
group by Calls.CountryCode, Calls.Date, SKILL_NUMBER, Calls.isNonClaim, ASA;