Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can any suggest how i can do best ageing for attached qvw file. and i need to calculate ovell ageing for call id 1 and 2 as below
total duration it should be like for call id 1 it solud be total duration of status thats 30 min[0-1] nd for call id 2 it shold be (6.50) fall duration under > [4]
Thanks in advance.
Hi,
In Resident table write some thing like this for ageing
Load
[Call Id],
if (Hour(Duartion) <=1,'[0-1]',
if (Hour(Duartion) >=1 and Hour(Duartion)<=2 ,'[2-2]',
if (Hour(Duartion) >=2 and Hour(Duartion)<=3 ,'[2-3]',
if (Hour(Duartion) >=3 and Hour(Duartion)<=4 ,'[3-4]',
if (Hour(Duartion) >=4 and Hour(Duartion)<=5 ,'[4-5]',
if (Hour(Duartion) >=5 and Hour(Duartion)<=6 ,'[5-6]'))))))
as ageing
Resident Book1;
Regards,
Anand
Not sure what you exactly looking for, check and let me know
Thank for quick reply.
its helpfull one but why its not filtred as for ageing selection
thanks
Thank for quick reply.
its helpfull one but why its not filtred as for ageing selection
thanks
When you filter by age selection obviously it will show as per hour selection.
Better go with aggregation function
Hi Sivaraj,
Thanks for your suggestion do you guide how i can add this into my attached sample file
it should do aggregartion or sum of duration for selected ageing
Thanks