Learn how to compute the rank of a row and return that rank in an ordered group of rows.
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.