Spreadsheet: 476988d1472097036-pivot-question-coolzero-pivot-question
Sheet: Pivot Graph-MTD

Team Leader | Laxamana, Julius
NPS Goal | 0.65
Agent Name | Tenure Days (EOM) | Month | Bucket | # of Surveys | NPS% | RSAT% | IR% | FCR% | Average of Target
Cabintoy, [NAME] | 125 | Jan | C |  | 0.4375 | 0.8125 | 0.8125 | 0.8125 | 0.65
 | 154 | Feb | A | 14 | 0.7857142857142857 | 0.9285714285714286 | 0.9285714285714286 | 0.7857142857142857 | 0.65
 | 185 | Mar | A | 20 | 0.9 | 0.95 | 0.9 | 0.8 | 0.65
 | 215 | Apr | A | 17 | 0.8235294117647058 | 0.9411764705882353 | 0.9411764705882353 | 0.8823529411764706 | 0.65
 | 246 | May | C |  | 0.3529411764705882 | 0.8823529411764706 | 0.9411764705882353 | 0.8235294117647058 | 0.65
 | 276 | Jun | C |  | 0.35 | 0.75 | 0.85 | 0.85 | 0.65
 | 307 | Jul | A | 6 | 0.8333333333333334 | 1 | 1 | 1 | 0.65
 | 338 | Aug | A | 6 | 0.8333333333333334 | 0.8333333333333334 | 1 | 0.8333333333333334 | 0.65
Cabintoy, [NAME] |  |  |  |  | 0.6645439425770308 | 0.8872417717086835 | 0.9216780462184874 | 0.8484287464985993 | 0.65
Calderon, [NAME] | 244 | Jan | A | 25 | 0.88 | 0.92 | 0.92 | 0.92 | 0.65
 | 273 | Feb | A | 14 | 0.8571428571428572 | 1 | 1 | 1 | 0.65
 | 304 | Mar | A | 10 | 0.7000000000000001 | 0.9 | 1 | 0.8 | 0.65
 | 334 | Apr | A | 17 | 0.7058823529411764 | 0.8823529411764706 | 0.8823529411764706 | 0.7647058823529411 | 0.65
 | 365 | May | A | 23 | 0.7826086956521738 | 0.9565217391304348 | 0.9565217391304348 | 0.9130434782608695 | 0.65
 | 395 | Jun | A | 20 | 0.9 | 1 | 1 | 1 | 0.65
 | 426 | Jul | A | 8 | 0.875 | 1 | 1 | 1 | 0.65
 | 457 | Aug | A | 8 | 0.75 | 1 | 0.875 | 0.875 | 0.65
Calderon, [NAME] |  |  |  |  | 0.806329238217026 | 0.9573593350383631 | 0.9542343350383632 | 0.9090936700767263 | 0.65
Cortez, [NAME] | 93 | Aug | C |  | 0.4545454545454545 | 0.9090909090909091 | 0.9 | 0.9090909090909091 | 0.65
Cortez, [NAME] |  |  |  |  | 0.4545454545454545 | 0.9090909090909091 | 0.9 | 0.9090909090909091 | 0.65
Igaloy, [NAME] | 177 | Aug | A | 10 | 0.8 | 1 | 1 | 0.9 | 0.65
Igaloy, [NAME] Total |  |  |  |  | 0.8 | 1 | 1 | 0.9 | 0.65
Lopez, Aleli Medina | 405 | Jan | A | 15 | 0.6666666666666666 | 0.9333333333333333 | 0.9333333333333333 | 0.9333333333333333 | 0.65
 | 434 | Feb | A | 17 | 0.9411764705882353 | 1 | 1 | 0.9411764705882353 | 0.65
 | 465 | Mar | A | 20 | 0.7 | 0.9 | 0.95 | 0.75 | 0.65
 | 495 | Apr | A | 27 | 0.8518518518518519 | 0.9629629629629629 | 0.9259259259259259 | 0.8148148148148148 | 0.65
 | 526 | May | A | 21 | 0.7619047619047619 | 0.9523809523809523 | 1 | 0.8571428571428571 | 0.65
 | 556 | Jun | A | 16 | 0.6875 | 0.875 | 0.875 | 0.875 | 0.65
 | 587 | Jul | C |  | 0.4285714285714285 | 0.8571428571428571 | 1 | 0.8571428571428571 | 0.65
Lopez, Aleli Medina Total |  |  |  |  | 0.7196673113689921 | 0.9258314436885865 | 0.9548941798941799 | 0.8612300475745853 | 0.65
Napao, Marvin Palando | 93 | Aug | B | 5 | 0.6000000000000001 | 0.8 | 1 | 1 | 0.65
Napao, Marvin Palando Total |  |  |  |  | 0.6000000000000001 | 0.8 | 1 | 1 | 0.65
[NAME], [NAME] | 136 | Jun | A | 20 | 0.75 | 0.9 | 0.95 | 0.95 | 0.65
 | 167 | Jul | A | 18 | 0.8333333333333333 | 0.9444444444444444 | 0.9444444444444444 | 0.9411764705882353 | 0.65
 | 198 | Aug | A | 8 | 0.875 | 1 | 1 | 1 | 0.65
[NAME], [NAME] |  |  |  |  | 0.8194444444444443 | 0.9481481481481482 | 0.9648148148148148 | 0.9637254901960784 | 0.65
Grand Total |  |  |  |  | 0.7281908763384202 | 0.9238332521838563 | 0.9477931984054658 | 0.8892778291484085 | 0.65