Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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:

Before Filter

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:

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

1 Answer

0 votes
by (47.2k points)

  • You can create your Filter based on the University field, and use the condition tab to specify your criteria

  • Else You can also use the top tab to limit the number of universities

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories