I'm attempting to create a dashboard panel that creates a count of "Roles" by Role_Names, however, I need to exclude specific field values from a dynamic field labeled "Roles" based on the Role_Name.
For example, if I have Role_Name=Security AND Roles=A, B, C, D, I want to exclude all those "Roles" for that specific "Role_Name and return a count value of "0". However, today, the "Roles" for Role_Name=Security can equal A, B, C, & D but next week it might equal A, B, & F, in this case, I'd want to still exclude A & B but count F.
Additionally, Roles can be associated with other Role_Names so I can't just exclude them from the search altogether. I know there's a way to accomplish this I just can't recall it. Any assistance is greatly appreciated.