Template
Top related items
How to find the top four items in a list
Industry:
n/a
Function:
Other
This app shows how to find the top few related items for a particular item. In this example, there are Items and Coupons. When viewing a particular item, this app displays:
- all related coupons
- the top 4 coupons, by price
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
To get the top few coupons, we combined an ORDERBY formula with a TOP formula. Here's the formula:
TOP(ORDERBY([Item Coupons], [Discount], TRUE), 4)
Anatomy of this formula:
- [Item Coupons] are the related coupons for a particular item
- ORDERBY([Item Coupons], [Discount], TRUE) orders the coupons by the Discount column, and the TRUE column specifies descending order
- TOP(..., 4) returns the first four rows returned by the ORDERBY
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...