Assistance with Grouping Brands into "Other" Category Based on Placements in QuickSight

Hi @Nikhilburhade,
While I don’t have a sample dataset similar to this build that I can test this out; what if you created a denserank for your brands based on placement. Then you can use that field in your x-axis and instead of applying a top/bottom filter, limit the number of data points to show (5 if you want the top 5) and that will automatically group the remaining values in to an ‘other’ category.

If this does not work for your case; it would be a lot easier to assist further if you’re able to upload an sample copy of your analysis to the QuickSight Arena view as that will be a lot easier to test out a potential work around.

1 Like