Top/Bottom N Filter with Context (Effected by another filter)

Question & Answer
, ,
1

Hello - I am working with a dataset where I have rating scores from employees from many different companies. I’m looking to create a visual where I look at the bottom 10 averaged company scores. However, I’d also like to adjust the minimum number of employees who submitted scores with a second filter. For example, I’d like to see the bottom 10 company scores where there were at least 50 employees submitting scores and then I’d like to be able to adjust that minimum up to 100 employee scores and have a new set of bottom 10 companies.

In Tableau, I could add the minimum count as a “context filter” so that the list of companies dynamically changes. But in Quicksight, when I adjust the minimum response count, it simply excludes those companies (and might show me only 3 out of 10). Is there a way to do this in Quicksight?

1 Like
2

Hi @erweinstein7
you want to have different visuals or one visual where you adjust the # of employees?
BR

3

Hi @ErikG - looking for this in one visual. So adjusting # of employees to 50 shows 10 companies with lowest scores that meet that threshold, and then adjusting # of employees to 100 now shows the 10 companies that meet that new threshold.

4

Hi @erweinstein7
you could use a combination of ifelse, rank and a parameter

something like:

create a new_score based on #employees

ifelse( #employees >= parameter#employees, score, 0)

rank the companys

rank(sum(new_score) ASC)

filter on rank

BR

1 Like
5

Hi @erweinstein7,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @erweinstein7,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!