Best way to leverage a top n filter if there are more than 100 values

[Eli]

I have a bar chart with a max value of 100 on the Y axis and placing other values in the ‘Other’ category. I understand how this works but want to hide the ‘Other’ category to reduce any confusion for end users. At the same time, I would like to be able to apply a Top N filter that allows users to see more than the Top 100. I attempted creating a rank slider but could not accomplish this.
Below is a screenshot of what I am attempting to apply a filter to.

The Unique Rider Category Selection is a simple ifelse() allowing for data slicing. Basically replacing the drill through. I would like to rank patients based on count(ride_id) and to be able to show the top 100 or the next 100 after the top 100 without having to guess the max value my filter needs to be set at.

Thanks in advance for any help!

[Naveed]

Hi,

this may help you

Last N days from a selected date

Hi, I have a table wit day, week, and month granularity, and I want to create a control like this to let user select a date and how many days/weeks/months value they want to see. The idea is to let the Last N day control change days/weeks/months value at the same time, so when N = 8, users should be able to see 8 days/ 8 weeks/ 8 months value. [Screen Shot 2022-11-23 at 3.11.31 PM] My current setting for the filter is like this: [Screen Shot 2022-11-23 at 3.14.26 PM] time rank is a number c…

regards,
Naveed Ali

[Eli]

Hi Naveed,

I was unable to find a solution to this, unfortunately.

[yingliao422]

Hi @Eli, you can create a calculated field with a rank function, sort by count(ride_id). And then use the calculated field in parameterized filter to implement pagination.

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!