Parent Case SLA Report

SLA based on < Working Hours (exclude weekends, public holidays and after office hour)

Year 2018

Year 2019

Breached SLA Parent Cases

Filtered:
- Date is filtered > 2018-09-01
- SLA breached >8 hours

Breached Case History

Distribution

Cycle Hours Distribution

parent.case.hours %>% 
  filter(TotalHours<16) %>%
  ggplot( aes(x=TotalHours)) + geom_histogram(binwidth = 1) +
  xlab('Hours')

Number of Cycles Distribution

parent.case.hours %>% 
  #filter(Cycle<16) %>%
  ggplot( aes(x=Cycle)) + geom_histogram(binwidth = 1) +
  xlab('Hours') +
  facet_grid( Country~.)

LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6DQogIGh0bWxfbm90ZWJvb2s6DQogICAgY29kZV9mb2xkaW5nOiBoaWRlDQogICAgbnVtYmVyX3NlY3Rpb25zOiBubw0KICAgIHRoZW1lOiBjZXJ1bGVhbg0KICAgIHRvYzogeWVzDQogICAgdG9jX2RlcHRoOiA0DQogICAgdG9jX2Zsb2F0OiB5ZXMNCiAgaHRtbF9kb2N1bWVudDoNCiAgICBkZl9wcmludDogcGFnZWQNCiAgICB0b2M6IHllcw0KICAgIHRvY19kZXB0aDogJzQnDQotLS0NCg0KYGBge3IgbG9hZCBsaWJyYXJpZXMsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGluY2x1ZGU9RkFMU0V9DQpsaWJyYXJ5KHRpZHl2ZXJzZSkNCmxpYnJhcnkoc2FsZXNmb3JjZXIpDQpsaWJyYXJ5KGRhdGEudGFibGUpDQpsaWJyYXJ5KHN0cmluZ3IpDQpsaWJyYXJ5KGx1YnJpZGF0ZSkNCmxpYnJhcnkoZmFzdHRpbWUpDQpsaWJyYXJ5KERUKQ0KbGlicmFyeSh6b28pDQpsaWJyYXJ5KGdncGxvdDIpDQpgYGANCg0KYGBge3IgcmVhZCBmaWxlcywgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgaW5jbHVkZT1GQUxTRX0NCiMjIEN1cnJlbnQgZHBjIHVzZXJzIGFuZCBncm91cHMgKGluY2x1ZGVzIGFjdGl2ZSBhbmQgaW5hY3RpdmUpDQpkcGMudXNlcnMgPSBmcmVhZChmaWxlPSdkYXRhL2RwY191c2Vycy5jc3YnKQ0KZHBjLnVzZXJzJGlzLkRwY1RBID0gZ3JlcGwoJ1NvbHV0aW9uIENvbnN1bHRhbnQnLCBkcGMudXNlcnMkVXNlclJvbGUuTmFtZSkNCmRwYy51c2VycyRpcy5EcGNTQSA9IGdyZXBsKCdTYWxlcyBBZG1pbicsIGRwYy51c2VycyRVc2VyUm9sZS5OYW1lKQ0KDQpkcGMuc2xhLnN1bW1hcnkuMjAxOCA9IGZyZWFkKGZpbGU9J2RhdGEvZHBjX3NsYV9zdW1tYXJ5XzIwMTgnKQ0KZHBjLnNsYS5zdW1tYXJ5LjIwMTkgPSBmcmVhZChmaWxlPSdkYXRhL2RwY19zbGFfc3VtbWFyeV8yMDE5JykNCg0KcGFyZW50LmNhc2UuaG91cnMgPSBmcmVhZChmaWxlPSdkYXRhL3BhcmVudC5jYXNlLmhvdXJzJykNCnBhcmVudC5jYXNlLmhpc3RvcnkgPSBmcmVhZChmaWxlPSdkYXRhL3BhcmVudC5jYXNlLmhpc3RvcnknKQ0KYGBgDQoNCiMgUGFyZW50IENhc2UgU0xBIFJlcG9ydA0KDQpTTEEgYmFzZWQgb24gPCBXb3JraW5nIEhvdXJzIChleGNsdWRlIHdlZWtlbmRzLCBwdWJsaWMgaG9saWRheXMgYW5kIGFmdGVyIG9mZmljZSBob3VyKQ0KDQojIyBZZWFyIDIwMTgNCg0KYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0NCmRwYy5zbGEuc3VtbWFyeS4yMDE4ICU+JQ0KICBzZWxlY3QoQ291bnRyeSxtLFNsYThIcikgJT4lDQogIHNwcmVhZChtLFNsYThIcikgJT4lDQogIGRhdGF0YWJsZShyb3duYW1lcyA9IEZBTFNFKSAlPiUNCiAgZm9ybWF0Um91bmQoMjoxMywgMikNCmBgYA0KDQojIyBZZWFyIDIwMTkNCg0KYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0NCmRwYy5zbGEuc3VtbWFyeS4yMDE5ICU+JQ0KICBzZWxlY3QoQ291bnRyeSxtLFNsYTlIcikgJT4lDQogIHNwcmVhZChtLFNsYTlIcikgJT4lDQogIGRhdGF0YWJsZShyb3duYW1lcyA9IEZBTFNFKSAlPiUNCiAgZm9ybWF0Um91bmQoMjoxMywgMikNCmBgYA0KDQojIEJyZWFjaGVkIFNMQSBQYXJlbnQgQ2FzZXMNCg0KKipGaWx0ZXJlZDoqKiAgDQotIERhdGUgaXMgZmlsdGVyZWQgPiAyMDE4LTA5LTAxICANCi0gU0xBIGJyZWFjaGVkID44IGhvdXJzDQoNCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9DQpkcGMuZGVsYXllZC5jYXNlcyA9IHBhcmVudC5jYXNlLmhvdXJzICU+JSBmaWx0ZXIgKCFXaXRoaW44SHIsIENhc2VPd25lcnNoaXAgPT0gJ0RQQycpICU+JQ0KICBzZWxlY3QoQ2FzZUlkLCBDYXNlTnVtYmVyICwgQ291bnRyeSwgQ3JlYXRlZERhdGUsIEN5Y2xlLCBUb3RhbEhvdXJzKSAlPiUNCiAgZmlsdGVyIChDcmVhdGVkRGF0ZSA+PSBhcy5EYXRlKCcyMDE4LTA5LTAxJykpICU+JQ0KICBhcnJhbmdlKENhc2VOdW1iZXIsIEN5Y2xlKQ0KDQpkYXRhdGFibGUoZHBjLmRlbGF5ZWQuY2FzZXMsIHJvd25hbWVzID0gRkFMU0UsIGZpbHRlcj0ndG9wJykgJT4lDQogIGZvcm1hdFJvdW5kKCdUb3RhbEhvdXJzJywgMikgJT4lDQogIGZvcm1hdERhdGUoJ0NyZWF0ZWREYXRlJywgJ3RvTG9jYWxlU3RyaW5nJykNCmBgYA0KDQoNCiMgQnJlYWNoZWQgQ2FzZSBIaXN0b3J5DQoNCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9DQpicmVhY2hlZC5jYXNlLmhpc3RvcnkgPSBkaXN0aW5jdChkcGMuZGVsYXllZC5jYXNlcywgQ2FzZUlkKSAlPiUNCiAgbGVmdF9qb2luKHBhcmVudC5jYXNlLmhpc3RvcnkpICU+JSANCiAgc2VsZWN0KCBDYXNlSWQsIENhc2UuQ2FzZU51bWJlciwgQ3JlYXRlZERhdGUsT2xkVmFsdWUsTmV3VmFsdWUsQ2FzZU93bmVyc2hpcCxTdG9wcGVyLEN5Y2xlKSAlPiUNCiMgIHNlbGVjdChDYXNlSWQsIENyZWF0ZWREYXRlLCBDYXNlT3duZXJzaGlwLCBDeWNsZSwgVG90YWxIb3VycykgJT4lDQogIGFycmFuZ2UoQ2FzZUlkKQ0KDQpkYXRhdGFibGUoYnJlYWNoZWQuY2FzZS5oaXN0b3J5LCByb3duYW1lcyA9IEZBTFNFLCBmaWx0ZXI9J25vbmUnKSAlPiUNCiAjcmVjIGZvcm1hdFJvdW5kKCdUb3RhbEhvdXJzJywgMikgJT4lDQogIGZvcm1hdERhdGUoJ0NyZWF0ZWREYXRlJywgJ3RvTG9jYWxlU3RyaW5nJykNCmBgYA0KDQojIERpc3RyaWJ1dGlvbg0KDQojIyBDeWNsZSBIb3VycyBEaXN0cmlidXRpb24NCg0KYGBge3IgZmlnLndpZHRoPTl9DQpwYXJlbnQuY2FzZS5ob3VycyAlPiUgDQogIGZpbHRlcihUb3RhbEhvdXJzPDE2KSAlPiUNCiAgZ2dwbG90KCBhZXMoeD1Ub3RhbEhvdXJzKSkgKyBnZW9tX2hpc3RvZ3JhbShiaW53aWR0aCA9IDEpICsNCiAgeGxhYignSG91cnMnKQ0KYGBgDQoNCg0KIyMgTnVtYmVyIG9mIEN5Y2xlcyBEaXN0cmlidXRpb24NCg0KYGBge3IgZmlnLndpZHRoPTksIGZpZy5oZWlnaHQ9MTh9DQpwYXJlbnQuY2FzZS5ob3VycyAlPiUgDQogICNmaWx0ZXIoQ3ljbGU8MTYpICU+JQ0KICBnZ3Bsb3QoIGFlcyh4PUN5Y2xlKSkgKyBnZW9tX2hpc3RvZ3JhbShiaW53aWR0aCA9IDEpICsNCiAgeGxhYignSG91cnMnKSArDQogIGZhY2V0X2dyaWQoIENvdW50cnl+LikNCmBgYA==