The Top N filter works fine when it is applied alone to the visuals. However, when I add another regular dimension filter, only the Top N filter works. Similarly, the dimension filter only works when it is applied alone without the Top N filter.
This issue does not happen in Tableau.
Can you show a screenshot of the filters you have applied to your visual?
Sure. There are 2 filters. A top N filter on the Genre Dimension by Average Rating and another filter that display all genres that contains a genre inputted by the users.
The Top N filter should limit the data first followed by what the user type for chosen genre
1 Like
In some cases we want to apply the Top N filter before the other filters but in other cases the reverse.
- Filter by the genre first and then find the top 40 in that genre.
- Find the top 40 overall first and then filter to only show the selected genre.
I believe that in QuickSight does #1 but you want #2. Is that correct?
You don’t have this issue in Tableau because in Tableau you can use context filters to decide which filter to apply first.
2 Likes