3 Replies Latest reply on Oct 12, 2017 7:56 AM by Jim Dehner

Filtering Records with Two Primary Keys

Alexander Schraut Oct 12, 2017 7:16 AM

I have been lurking on this page for more than two years, and I have to say the help on this site is AMAZING! I really hope someone can help me out with this problem...And I hope I'm putting this request in the right place...

I have a large SQL DB that is updated daily from some internal systems and scripts I have running. One of my tables includes records for investigations, and it has two primary keys (Case ID and Owner). For each individual Case ID (unique number auto-assigned to each case), I will have multiple rows based on how many people have interacted with the case (owners). All other columns are the same for these rows except the owner. The problem I have is this...I have two distinct teams that work on these cases. I have grouped them and am now trying to filter all the Case IDs to show only those cases that only have someone from 1 team associated with the case. Ex. Bob, Susan, and Frank are with Team A, and John, Eddy, and Mark are with Team B. Case 1234567 is "owned" by Bob and Frank, but no one from Team B. I need to show this Case ID. Case 7654321 is owned by Susan, Frank, John, and Mark. I do not want to show this case since people from Team A and B "own" the case.

I hope this makes sense. I have attached a mock up data set and worksheet to demonstrate what I am looking at. The end result I am looking for is what is shown on Sheet 1 except with all the cases that are owned by both teams removed. I am currently use version 10.1.5.

Thank you in advance for your help!

HelpExample.twbx 24.9 KB

1. Re: Filtering Records with Two Primary Keys

Jim Dehner Oct 12, 2017 7:35 AM (in response to Alexander Schraut)
Good morning Alexander
I'm a little confused by your example becxause I could not find the cases you referenced but that said I think you want to Identify thos cases where all the participants are from the same team

First on a case by case basis I determined the Min and Max "Team" since is is a alpha continuum Team A and Team B are distinct in the sense if both are present Min will not = Max

Then I put in a filter

It will return this based on the chart in your file

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

HelpExample.twbx 47.3 KB
Like Show 0 Likes(0)

Actions
2. Re: Filtering Records with Two Primary Keys

Alexander Schraut Oct 12, 2017 7:56 AM (in response to Jim Dehner)

Jim,
Thank you for the quick response! This is exactly what I was looking for. As for the part that you were missing...The 6-digit numbers in [Case ID] are the cases that I was referring to. I removed all the other columns to reduce confusion.
Thanks again!
Like Show 0 Likes(0)

Actions
3. Re: Filtering Records with Two Primary Keys

Jim Dehner Oct 12, 2017 7:56 AM (in response to Alexander Schraut)

Glad to help out -

Thanks
Jim
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Filtering Records with Two Primary Keys

1. Re: Filtering Records with Two Primary Keys

2. Re: Filtering Records with Two Primary Keys

3. Re: Filtering Records with Two Primary Keys

Actions

More Like This