7 Replies Latest reply on Dec 10, 2012 10:24 AM by . Jasonz

# Need help filtering where a ticket have multiple groups

Hi Folks,

Need help with this one (I probably am missing something basic)

 grouping ticket OP Ticket 123 AB Ticket 123 AC Ticket 123 OP Ticket 1234 OP Ticket 12345 AB Ticket 12345 OP Ticket 12345

first question I need a way to take the above and only show the tickets with OP only and not any other group:

Ticket 1234 should be the only one that makes it through as the other ones contain other groups as well

• ###### 1. Re: Need help filtering where a ticket have multiple groups

Hi Jasonz,

A calculation similar to the following can be created:

if total(count(ticket))=1 then 1 else 0 end

Place this on the view, right click on it and select Compute Using-->Grouping. Then, right click on it again and select Filter... Filter out the 0s.

Hope this helps a bit!

-Tracy

• ###### 2. Re: Need help filtering where a ticket have multiple groups

Hi Tracy,

thanks for replying.... what if I also wanted both op and ab?

so ticket 1234 and 12345 are then valid?

JZ

• ###### 3. Re: Need help filtering where a ticket have multiple groups

bump... anyone can assist?

• ###### 4. Re: Need help filtering where a ticket have multiple groups

Attached is one way to do this, using IF statements to flag the rows and then multiple TOTAL statements to determine whether the conditions are met.

Jonathan

• ###### 5. Re: Need help filtering where a ticket have multiple groups

Hi Folks,

Nothing really worked on this one, let me try another way to explain the issue:

ticket #                         group

ticket 001                     abc

ticket 001                     abc

ticket 001                     abc

ticket 002                     abc

ticket 002                     123

ticket 002                     abc

ticket 002                     123

ticket 003                     abc

ticket 003                     abc

ticket 003                     abc

What I need is a way just to get tickets 001 and 003 to show (looking at group abc) every which way I try it will show ticket 002 also (just the abc row and not the 123 row) any ideas?

The results I want should look like

Ticket 001       abc

Ticket 003       abc

• ###### 6. Re: Need help filtering where a ticket have multiple groups

Hi,

If you want to do this for a single row, Tracy's solution will work, I also created an alternative in the attached. You can then put a parameter filter on top of that to just see which ones for the selected parameter.

To do a combination of N multiple values as you'd requested earlier, some set of custom calculations would be necessary and I'm not totally clear on the logic required there. It seems like it's this:

Given the set of grouping choices #1, #2, ... N, if the set of all groups for a given ticket fits within the choice set, then show that ticket, otherwise hide it.

Is that correct?

If so, then I can think of two ways to do this:

1. Have parameters to pick the grouping choices, so you would need N parameters for the number of simultaneous selections, and then some set of calculations underneath that would be used in the filter.

The reason parameters are needed is that you need to see all the data in order to determine which tickets will be excluded due to having values that haven't been chosen, so that rules out Quick Filters. Parameters don't support multi-select, so you'd have to go with multiple parameters.

2. Some sort of custom query to generate a list of all groups that a given ticket is in that would be an additional column in the table, then there could be custom calculations that would perform a secondary filter after the quick filter on group is used in order to filter out tickets that had more than the list of filtered groups.

Jonathan

• ###### 7. Re: Need help filtering where a ticket have multiple groups

thanks! that seems to have done it