How to Implement DENSE_RANK Functionality

Goal

Learn how to compute the rank of a row and return that rank in an ordered group of rows.

Learn

The attached the JSON definition of a workbook implements the functionality of DENSE_RANK step-by-step. The example creates a traditional rank list from the source sheet.

To get a better understanding of the functionality, the example provides a joined rank sheet with which you can compare the rank and dense rank results.

You can upload it as described in our documentation REST API - Create Workbook.

Attachment