Spreadsheet: 673117d1587179289-get-results-in-a-column-filtered-by-multiple-criteria-example
Sheet: raw data

ID | crea | agentUname | supUname | auditorUname | ticketNumber | dateOfCall | tenant | totalScore | outOfScore | auditScore | auditFor | typeOfContact | lineOfBus | agentSkillSet | callDispo | callDuration | callRecording | callSummary | coachingFeedback | coachingComplete | passRate |  |  | hidden | Demonstrate Concern | Establish Rapport/Personalization | Displayed Active Listening Skills/Responsiveness | Asked Relevant Probing Questions to Clarify Issues  (Communicated Understanding (Comprehension of Issue at Hand) | Take Responsibility / Ownership | Project Enthusiastic Tone | Convey Confidence | Provide complete and accurate information | Offer Products / Services Tailored to Needs (VIBE) | Explained Options/Resolution in a Clear, Organized  and Appropriate Manner  (Communicate with clarity) | Control Contact/Use Time Efficiently/Offer Additional Assistance | Inaccurate Documentation | Did not disposition the call correctly | Did not create ticket representative of Guest interaction (Guided Path) | Did not indicate any notes/documentation in the ticket | Missed in the Compliance Questions | q17 | q18 | q19 | q20 | [NAME] | q22 | q23 | q24 | Refused to Escalate | Vulgar/Abusive | Rudeness | Call Avoidance | [NAME] | af6 | [NAME] | [NAME] | af9 | af10 | af11 | af12 | af13 | af14 | qa_rating | Date | Week Starting | Calendar Month
2854 | 43783 | [NAME] |  |  |  | 43778 |  | 86 | 100 | 86 |  |  |  |  | prep | 0.2819444444444444 |  |  |  |  | Pass |  |  | 0 | 4 | 8 | 10 | 10 | 10 | 9 | 10 | 8 | 0 | 10 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43783 | 43779 | 2020-11-19 00:00:00
2867 | 43788 | jones |  |  |  | 43784 |  | 79.5 | 100 | 79.5 |  |  |  |  | prep | 0.3527777777777778 |  |  |  |  | Fail |  |  | 0 | 4 | 6 | 10 | 6 | 10 | 9 | 10 | 8 | 0 | 10 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Unsuccessful: NEW: Rep unable to find info to help | 100 | 43788 | 43786 | 2020-11-19 00:00:00
2872 | 43789 | wood |  |  |  | 43784 |  | 81 | 100 | 81 |  |  |  |  | prep | 0.28125 |  |  |  |  | Pass |  |  | 0 | 5 | 8 | 10 | 8 | 8 | 9 | 10 | 8 | 0 | 8 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43789 | 43786 | 2020-11-19 00:00:00
2879 | 43789 | jones |  |  |  | 43784 |  | 74.5 | 100 | 74.5 |  |  |  |  | prep | 0.2513888888888889 |  |  |  |  | Fail |  |  | 0 | 4 | 6 | 10 | 6 | 6 | 8 | 10 | 8 | 0 | 10 | 6.5 | 0 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 80 | 43789 | 43786 | 2020-11-19 00:00:00
2891 | 43794 | [NAME] |  |  |  | 43792 |  | 77 | 100 | 77 |  |  |  |  | prep | 0.3722222222222222 |  |  |  |  | Fail |  |  | 0 | 4 | 8 | 6 | 8 | 8 | 10 | 8 | 8 | 0 | 10 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43794 | 43793 | 2020-11-19 00:00:00
2899 | 43796 | clark |  |  |  | 43791 |  | 71 | 100 | 71 |  |  |  |  | prep | 0.3125 |  |  |  |  | Fail |  |  | 0 | 4 | 6 | 8 | 6 | 6 | 9 | 10 | 8 | 0 | 8 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43796 | 43793 | 2020-11-19 00:00:00
2913 | 43798 | folks |  |  |  | 43793 |  | 79.5 | 100 | 79.5 |  |  |  |  | prep | 0.3631944444444444 |  |  |  |  | Fail |  |  | 0 | 0 | 6 | 10 | 8 | 10 | 9 | 10 | 10 | 0 | 10 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43798 | 43793 | 2020-11-19 00:00:00
2924 | 43798 | [NAME] |  |  |  | 43796 |  | 87 | 100 | 87 |  |  |  |  | prep | 5.0833 |  |  |  |  | Pass |  |  | 0 | 5 | 10 | 8 | 10 | 10 | 10 | 8 | 10 | 0 | 10 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43798 | 43793 | 2020-11-19 00:00:00
2930 | 43798 | tinker |  |  |  | 43795 |  | 80.5 | 100 | 80.5 |  |  |  |  | prep | 7.85 |  |  |  |  | Pass |  |  | 0 | 4 | 8 | 10 | 6 | 8 | 10 | 10 | 8 | 0 | 10 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | Yes | N/A | Success: Answered Questions | 100 | 43798 | 43793 | 2020-11-19 00:00:00
2932 | 43798 | mcmillan |  |  |  | 43793 |  | 82.5 | 100 | 82.5 |  |  |  |  | prep | 5.1333 |  |  |  |  | Pass |  |  | 0 | 5 | 10 | 8 | 8 | 10 | 9 | 10 | 8 | 0 | 8 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43798 | 43793 | 2020-11-19 00:00:00
2935 | 43798 | [NAME] |  |  |  | 43793 |  | 81.5 | 100 | 81.5 |  |  |  |  | prep | 4.25 |  |  |  |  | Pass |  |  | 0 | 4 | 6 | 10 | 8 | 10 | 9 | 10 | 8 | 0 | 10 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43798 | 43793 | 2020-11-19 00:00:00
2943 | 43799 | ford |  |  |  | 43798 |  | 73 | 100 | 73 |  |  |  |  | prep | 4.1333 |  |  |  |  | Fail |  |  | 0 | 4 | 6 | 8 | 8 | 6 | 9 | 10 | 6 | 0 | 10 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43799 | 43793 | 2020-11-19 00:00:00
2945 | 43799 | [NAME] |  |  |  | 43798 |  | 84 | 100 | 84 |  |  |  |  | prep | 5.9833 |  |  |  |  | Pass |  |  | 0 | 4 | 8 | 8 | 10 | 10 | 9 | 10 | 8 | 0 | 10 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43799 | 43793 | 2020-11-19 00:00:00
2949 | 43799 | [NAME] |  |  |  | 43798 |  | 85 | 100 | 85 |  |  |  |  | prep | 6.8333 |  |  |  |  | Pass |  |  | 0 | 5 | 10 | 8 | 8 | 10 | 9 | 8 | 10 | 0 | 10 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43799 | 43793 | 2020-11-19 00:00:00
2950 | 43799 | wood |  |  |  | 43799 |  | 75 | 100 | 75 |  |  |  |  | prep | 4.6666 |  |  |  |  | Fail |  |  | 0 | 0 | 6 | 10 | 8 | 8 | 8 | 10 | 8 | 0 | 10 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43799 | 43793 | 2020-11-19 00:00:00
2970 | 43809 | clark |  |  |  | 43805 |  | 74 | 100 | 74 |  |  |  |  | prep | 6.3666 |  |  |  |  | Fail |  |  | 0 | 4 | 6 | 8 | 6 | 8 | 8 | 10 | 8 | 0 | 10 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43809 | 43807 | 2020-12-19 00:00:00
2980 | 43817 | matthews |  |  |  | 43814 |  | 80 | 100 | 80 |  |  |  |  | prop | 0.2402777777777778 |  |  |  |  | Pass |  |  | 0 | 4 | 8 | 8 | 8 | 10 | 8 | 10 | 8 | 0 | 10 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43817 | 43814 | 2020-12-19 00:00:00
3010 | 43825 | matthews |  |  |  | 43820 |  | 71 | 100 | 71 |  |  |  |  | gen | 0.2548611111111111 |  |  |  |  | Fail |  |  | 0 | 0 | 6 | 8 | 8 | 8 | 9 | 10 | 8 | 0 | 8 | 6 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43825 | 43821 | 2020-12-19 00:00:00
3014 | 43825 | [NAME] |  |  |  | 43820 |  | 81.5 | 100 | 81.5 |  |  |  |  | prep | 0.3416666666666666 |  |  |  |  | Pass |  |  | 0 | 4 | 6 | 10 | 8 | 10 | 9 | 10 | 8 | 0 | 10 | 6.5 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43825 | 43821 | 2020-12-19 00:00:00
3016 | 43825 | jones |  |  |  | 43820 |  | 81 | 100 | 81 |  |  |  |  | prep | 0.2486111111111111 |  |  |  |  | Pass |  |  | 0 | 4 | 6 | 10 | 8 | 10 | 8 | 10 | 10 | 0 | 8 | 7 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Yes | N/A | N/A | Success: Answered Questions | 100 | 43825 | 43821 | 2020-12-19 00:00:00