Reputation: 113

Tableau Filter to Apply Before Color Dimension

this should be a simple solution, but I attached some pictures to help explain.

I have a database of candidates who were spoken to at University campus career fairs. Each candidate has a rating (0-4) that the recruiter assigns the candidate based on their conversation.

I want a simple bar graph showing the number of records (candidates) spoken to at each university, and colors to show how many of each rating number there are.

I have:

Columns: CNT (Number of Records)
Rows: School Name
Color: Rating

The graph works perfectly before I apply any filters:

However, I want the dashboard only to display universities where 100+ candidates were spoken to. Essentially, I want to cut off the bottom universities from the display.

When I add a "number of records" filter to the worksheet, it only shows me universities with 100+ candidates with the same rating. Thus, instead of showing me the schools with 100+ candidates and their ratings based on color, it just shows me the (very few) schools that have 100+ students with the same rating.

Graph after I apply the filter:

How can I make sure the filter is being applied before the color dimension?

Thanks,

Andrew

Upvotes: 2

Answers (4)

JJBee

Reputation: 56

drag school name into filters, and use this formula in condition tab:

sum([Number of Records])>=100

Upvotes: 0

Petr Havlik

Reputation: 3317

Andrew Neeld, you could easily achieve this with Level of Detail Expressions. Try creating this formula:

{ FIXED [School Name] : COUNT[(Recruit Name]) } >= 100

This will calculate total number of candidates per school no matter how you build your report and return TRUE/FALSE whether the value is larger than 100. If you then drag this field onto filter pane and simply select TRUE.

I'd maybe suggest replacing the hard-coded mean value with parameter. Here is the link to LOD Overview. And some Jedi LOD examples. Hope this helps.

Upvotes: 0