index="rpa_aria" |eval Start=strptime(start,"%Y-%m-%d %H:%M:%S") |eval Stop=strptime(end,"%Y-%m-%d %H:%M:%S") |eval Instance = process_name + " - " + country |convert dur2sec(Stop) dur2sec(Start) |eval TimeDiff=(Stop - Start) |eval TAT=tostring(TimeDiff, "duration") |stats avg(TimeDiff) as AVTAT, sum(heartbeat) as Vol, sum(passed) as STP, sum(amount) as Val by Instance |lookup Bench.csv Instance AS Instance OUTPUT BenchSecs |lookup Bench.csv Instance AS Instance OUTPUT Owner |lookup Bench.csv Instance AS Instance OUTPUT Salary |eval BenchTAT = BenchSecs |eval BotTATpT = (AVTAT/Vol) |eval MSal=(Salary/12) |eval Delta=(BenchTAT-BotTATpT) |eval HB2B = (BenchTAT*Vol/3600) |eval Capacity = HB2B/((44*4)*0.886) |eval Delta% = 100 * (BenchSecs-BotTATpT) / BenchTAT |eval SalRed = (Capacity * MSal)*12 |eval LCY=case(Instance like "%Eswatini%","SZL",Instance like "%Lesotho%","LSL", Instance like "%Namibia%","NAD", Instance like "%Botswana%","BWP",Instance like "%Ghana%","GHS",Instance like "%Uganda%","UGX",Instance like "%Tanzania%","TZS",Instance like "%Malawi%","MWK",Instance like "%South Africa%","ZAR",Instance like "%Angola%","AOA",Instance like "%Congo%","CDF",Instance like "%Kenya%","KES",Instance like "%Mozambique%","MZN",Instance like "%Nigeria%","NGN",Instance like "%Zambia%","ZMW",Instance like "%Zimbabwe%","ZWL") |lookup FX.csv LCY AS LCY OUTPUT Rate |eval ZAR = if(Instance="Recon Bizwize File Transfer - Botswana",300000, SalRed * Rate) |eval ZARVal = (Val * Rate) |eval BotTAT = BotTATpT |eval STP% = (STP/Vol)*100 |table Instance, LCY, Rate, ZAR |sort - ZAR |addcoltotals ZAR
... View more
