View: Tops SKUs Sold

This article will help you learn about the fields available in the Top SKUs Sold view, the field types, descriptions and how the fields are calculated

Key Topics

Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

View Definition

This view is created as a real-time query that runs within Looker against the database and has the following fields available/visible for use:


Field Name Field Type Description Source / Calculation
Order Date Range Filter Select the date range for the orders to include in the query Filters the order_date used to determine what orders to use in the query
Top n SKUs Parameter Enter a number to determine how many SKUs you want to include in the query Limits the number of SKUs used in the query ranked by total sold during the time period selected


This view is part of the following explores:

  • SKU Level Repurchase Rates

Transformation Code

This view is created within Looker as part of a Dynamic query which selects the following data from source tables to generate the final output from the query