Spreadsheet: 885825d1735671035-count-unique-values-of-column-x-based-on-filtered-values-of-column-y-unique
Sheet: Sheet1

 |  | Service Account
 |  |  |  |  |  | working, but overcomplicated first attempt
 | User ID | Role | Type
 | admin | rest_api_builder | Service Account
 | admin | admin | Service Account
 | admin | sn_employee.admin | Service Account
 | admin | security_admin | Service Account
 | admin | playbook.write | Service Account
 | admin | approval_admin | Service Account
 | dynatrace_integration | rest_api_builder | Service Account
 | erp_integration | business_rule_admin | Service Account
 | grantli_admin | approval_admin | Personal Account
 | grantli_admin | security_admin | Personal Account
 | grantli_admin | playbook.write | Personal Account
 | grantli_admin | rest_api_builder | Personal Account
 | grantli_admin | sn_employee.admin | Personal Account
 | grantli_admin | admin | Personal Account
 | GRC.System | ui_action_admin | Service Account
 | GRC.System | workspace_admin | Service Account
 | GRC.System | admin | Service Account
 | GRC.System | sn_employee.admin | Service Account
 | GRC.System | playbook.write | Service Account
 | GRC.System | rest_api_builder | Service Account
 | GRC.System | approval_admin | Service Account
 | heynser_admin | security_admin | Personal Account
 | heynser_admin | sn_employee.admin | Personal Account
 | heynser_admin | admin | Personal Account
 | heynser_admin | rest_api_builder | Personal Account
 | heynser_admin | approval_admin | Personal Account
 | heynser_admin | playbook.write | Personal Account
 | hradmin | approval_admin | Service Account
 | hradmin | rest_api_builder | Service Account
 | import_admin | rest_api_builder | Service Account
 | import_admin | approval_admin | Service Account
 | import_admin | admin | Service Account
 | import_admin | sn_employee.admin | Service Account
 | import_admin | playbook.write | Service Account
 | isim_adapter | client_script_admin | Service Account
 | isim_adapter | user_admin | Service Account
 | isim_adapter | personalize_rules | Service Account
 | isim_adapter | rest_api_builder | Service Account
 | isim_adapter | user_admin | Service Account
 | isim_adapter | ui_action_admin | Service Account
 | isim_adapter | business_rule_admin | Service Account
 | isim_adapter | user_admin_write | Service Account
 | lareama_admin | playbook.write | Personal Account
 | lareama_admin | admin | Personal Account
 | lareama_admin | sn_employee.admin | Personal Account
 | lareama_admin | approval_admin | Personal Account
 | lareama_admin | rest_api_builder | Personal Account
 | mcminbr_admin | rest_api_builder | Personal Account
 | mcminbr_admin | sn_employee.admin | Personal Account
 | mcminbr_admin | approval_admin | Personal Account
 | mcminbr_admin | playbook.write | Personal Account
 | mcminbr_admin | admin | Personal Account
 | pickema_admin | sn_employee.admin | Personal Account
 | pickema_admin | admin | Personal Account
 | pickema_admin | playbook.write | Personal Account
 | pickema_admin | rest_api_builder | Personal Account
 | pickema_admin | approval_admin | Personal Account
 | pickema_admin | security_admin | Personal Account
 | sanchiv2_admin | approval_admin | Personal Account
 | sanchiv2_admin | admin | Personal Account
 | sanchiv2_admin | playbook.write | Personal Account
 | sanchiv2_admin | rest_api_builder | Personal Account
 | sanchiv2_admin | sn_employee.admin | Personal Account
 | snowflake_API | rest_api_builder | Service Account
 | snowflake_API | approval_admin | Service Account
 | VR.System | workflow_creator | Service Account
 | VR.System | workflow_admin | Service Account
 | VR.System | workflow_publisher | Service Account
 | _splunk | playbook.write | Service Account
 | singhth | user_admin | Personal Account
 | singhth | user_admin | Personal Account
 | ahujaan | rest_api_builder | Personal Account
 | ahujaan | asset | Personal Account
 | auranje | rest_api_builder | Personal Account
 | auranje | asset | Personal Account
 | GBingham | rest_api_builder | Personal Account
 | GBingham | asset | Personal Account
 | boyersc | rest_api_builder | Personal Account
 | boyersc | asset | Personal Account
 | eagerle | rest_api_builder | Personal Account
 | eagerle | approval_admin | Personal Account
 | cprimian | rest_api_builder | Personal Account
 | cprimian | approval_admin | Personal Account
 | carpeje1 | rest_api_builder | Personal Account
 | carpeje1 | approval_admin | Personal Account
 | chudnbe | asset | Personal Account
 | chudnbe | rest_api_builder | Personal Account
 | critedo | change_manager | Personal Account
 | critedo | asset | Personal Account
 | critedo | rest_api_builder | Personal Account
 | critedo | approval_admin | Personal Account
 | [NAME] | rest_api_builder | Personal Account
 | [NAME] | asset | Personal Account
 | doylejo1 | asset | Personal Account
 | doylejo1 | rest_api_builder | Personal Account
 | ekkirsa | user_admin | Personal Account
 | ekkirsa | user_admin | Personal Account
 | eliama | rest_api_builder | Personal Account
 | eliama | asset | Personal Account
 | [NAME] | rest_api_builder | Personal Account
 | [NAME] | asset | Personal Account
 | garcidi3 | rest_api_builder | Personal Account
 | garcidi3 | asset | Personal Account
 | rg00020 | playbook.write | Personal Account
 | gollajy | rest_api_builder | Personal Account
 | gollajy | asset | Personal Account
 | goodwed | asset | Personal Account
 | goodwed | rest_api_builder | Personal Account
 | grantli | rest_api_builder | Personal Account
 | grantli | asset | Personal Account
 | griffde3 | rest_api_builder | Personal Account
 | griffde3 | asset | Personal Account
 | hallbe2 | asset | Personal Account
 | hallbe2 | rest_api_builder | Personal Account
 | hernapa4 | playbook.write | Personal Account
 | heynser | asset | Personal Account
 | heynser | rest_api_builder | Personal Account
 | hulinmi | playbook.write | Personal Account
 | IngwersenJ | rest_api_builder | Personal Account
 | IngwersenJ | asset | Personal Account
 | JK00059 | asset | Personal Account
 | JK00059 | rest_api_builder | Personal Account
 | [NAME] | asset | Personal Account
 | [NAME] | rest_api_builder | Personal Account
 | [NAME] | asset | Personal Account
 | [NAME] | rest_api_builder | Personal Account
 | shankca | rest_api_builder | Personal Account
 | shankca | approval_admin | Personal Account
 | luntbr | asset | Personal Account
 | luntbr | approval_admin | Personal Account
 | luntbr | change_manager | Personal Account
 | luntbr | rest_api_builder | Personal Account
 | luzvi | asset | Personal Account
 | luzvi | rest_api_builder | Personal Account
 | mcminbr | asset | Personal Account
 | mcminbr | rest_api_builder | Personal Account
 | medagni | rest_api_builder | Personal Account
 | medagni | asset | Personal Account
 | mocarsc | rest_api_builder | Personal Account
 | mocarsc | asset | Personal Account
 | muellbr | asset | Personal Account
 | muellbr | rest_api_builder | Personal Account
 | napheja | rest_api_builder | Personal Account
 | napheja | asset | Personal Account
 | palabkn | rest_api_builder | Personal Account
 | palabkn | asset | Personal Account
 | patelsh | user_admin | Personal Account
 | patelsh | user_admin | Personal Account
 | pwernes2 | rest_api_builder | Personal Account
 | pickema | asset | Personal Account
 | pickema | rest_api_builder | Personal Account
 | purneki | rest_api_builder | Personal Account
 | ramingo | asset | Personal Account
 | ramingo | rest_api_builder | Personal Account
 | reinhjo4 | asset | Personal Account
 | reinhjo4 | rest_api_builder | Personal Account
 | handwal | rest_api_builder | Personal Account
 | handwal | approval_admin | Personal Account
 | sanchiv2 | rest_api_builder | Personal Account
 | sanchiv2 | asset | Personal Account
 | singlde | playbook.write | Personal Account
 | stimpda | asset | Personal Account
 | stimpda | rest_api_builder | Personal Account
 | [NAME] | rest_api_builder | Personal Account
 | [NAME] | asset | Personal Account
 | vootlad | user_admin | Personal Account
 | vootlad | user_admin | Personal Account
 | whippje | asset | Personal Account
 | whippje | rest_api_builder | Personal Account
 | willit15 | asset | Personal Account
 | willit15 | rest_api_builder | Personal Account
 | wilsoja2 | asset | Personal Account
 | wilsoja2 | playbook.write | Personal Account
 | wilsoja2 | rest_api_builder | Personal Account
 | wolfejo | asset | Personal Account
 | wolfejo | rest_api_builder | Personal Account