Hi all,

We are trying to create some visualizations with Top-N filtering (top-10 subregions by sales, as an example), with the inclusion of an "others" bucket for 11+, but we're having a problem.

There are plenty of examples out there that show how to do this across your entire working data set, using Rank by and casing to rename everything outside Top-10 as "Other" and then leveraging the calculated column as your attribute displaying the Top-11. But those are all rank across the entire working dataset.

We need this to respect filters on the visualizaton. So, for example, we have two dimensions for Period (Year/Month) and Region. We want to display the Top 10 subregions in sales in January, 2025 in the Northern Region, bucketing the remaining into an "other" bucket.

In core SQL, this is easy. The Rank function has a partition by clause available, which creates multiple ranks per your slices of the data. However, OAS 2025 does not seem to contain this clause in the Rank function. The syntax checker kicks errors if you attempt to use it, and there is no discussion of partition by in the documentation.

Has anyone developed a way to do this in OAS? Do I need to open up a feature request and hope they figure it out in 2026 or 7?