Hi v-danhe-msft,

I'm trying to make a way to filter my Zendesk data, first by groups the ticket is assigned to based off of people in teams, and then by everyone in that team (since there are multiple team's people in the same group) and unassigned tickets from those groups.

That means I need to get a list of groups based off of teams,  and then looking at that list of groups I just created, I need to select different people and the unassigned tickets.

Here's an example of how I did it manually...I'm now trying to find a more automatic way since I won't know when people get added to different groups:

I first created a table with the assignee name and group name in it...Then I filter the table by people within a team to determine which groups they are a part of:

After I know the groups I filter the table to only see those groups, but more people than I want show up in the column:

So then I need to filter the table to only look at the people in the team I want and the unassigned tickets for those groups:

This is what the finished product would look like;

Do you know if there's a way I could do this, or do you think I'll have to just keep doing it manual and hope no one changes groups any time soon?

In the mean time I'm going to try the GENERATE function.

Thanks so much for your help,

Morganne