I have a list of product SKUs and the revenue they generated in a certain period.
The list of SKUs is really long, so I’d like to able to filter to a specific SKU within that list and return the surrounding 10 products (5 above and 5 below) when ranked by revenue.
The user would filter the SKU to
30010492910, and the Look would return 11 rows, with the filtered SKU in the middle, ranked by revenue. Displaying the rank would be ideal.
Here’s an example of the expected output (with fewer rows):
Any idea how to accomplish this?
Sorry for the late reply Josh! If you haven’t figured this out already,I think you could do this with some subqueries in SQL. Not sure if there’s a Looker magic spell here that will make things that much simpler, but filters sure are nice.
It’s not too complex as a derived table. I used a movies dataset we’ve got: