TAT calculation

[nareshthavidishetty]

hi all,

I got a requirement to calculate TAT

I got process,sub-process,start time end time received time

I need to calculate TAT every 2nd working day of the Month ,excluding weekends and holidays

how can I create a flag 2nd working day of month in the script

please help me

[tresesco]

May be like:

Load

          If (YourDateField=lastWorkDate(MonthStart(YourDateField),2), 1,0) as SecondWdayFlag

[nareshthavidishetty]

not working

[tresesco]

Could you post a qvw with sample data?

[nareshthavidishetty]

sorry flag is working now and I want to calculate the TAT based on this so how to handle this things

logic is end date time-received date time for tat calculation so please tell me I need to consider excluding weekends and holidays while calculating TAT

[tresesco]

Sorry, I could really not understand your requirement.

[veeranj]

Hi ,

Try filtering weekends from your mastercalendar with below script

load *  resident mastercalendar where not  match(weekDay,'Sat','Sun') ;

and use below script

load Month,FirstSortedValue([Facts_Dates],[Facts_Dates],2) as sec,'Y' as flag Resident MasterCalendar group by Month;

which will give 2nd working date in each month .

Thanks,

Anjee

[nareshthavidishetty]

I'm calculating TAT , I don't know how to calculate TAT

end date time-received date time gives TAT time excluding sat, Sunday  holidays

so I need to build which processes TAT met and not met

the reason y I asked 2nd working day of every month is if the process received date is  on 3rd it is missed TAT so I need to build in the script whether that process received on that day or later

is it clear or do I need to specify more in details please ask me I'm in need of help as I don't no how to handle this things

process,start date time ,end date time, received date time fields I'm using this fields

I build calender excluding sat,sun

[nareshthavidishetty]

I'm calculating TAT , I don't know how to calculate TAT

end date time-received date time gives TAT time excluding sat, Sunday  holidays

so I need to build which processes TAT met and not met

the reason y I asked 2nd working day of every month is if the process received date is  on 3rd it is missed TAT so I need to build in the script whether that process received on that day or later

is it clear or do I need to specify more in details please ask me I'm in need of help as I don't no how to handle this things

process,start date time ,end date time, received date time fields I'm using this fields

I build calender excluding sat,sun