How to filter a visualization to just the top N rows

Patterns
1

Currently the quickest way to do this in Omni is to have a two workbook tab structure that leverages XLookup. We can start with the initial tab of unfiltered data that we want to look at. Then, we can duplicate the tab and remove the measures and calculations that may exist there. After that, we will add in an XLookup to pull in the relevant values before limiting the query.

1 Like