Overview

The tabulate method in Rich Data Services is available for users to create tabulations and aggregations of their data.

Supported Functions

The tabulate method supports the following functions for the measures.

Step By Step

• To create a tabulation we will need to specify our dimensions (the topics of interest) and measures (quantities being counted). The most basic tabulation would just be a count of the values for the dimension.

  Basic Tabulation

  {host}/rds/catalog/test/view/tabulate?dims=var

  Tabulation Output Expand source

   {
      "records": [
          [
              1,
              182
          ],
          [
              2,
              354
          ],
          [
              3,
              126
          ]
      ],
      "info": {
          "colCount": 2,
          "format": "MTNA",
          "includeMetadata": false,
          "limit": 20,
          "offset": 0,
          "moreRows": false
      }
  }

• To add a measure, fill out the measure parameter with a computed variable.

  Basic Tabulation

  {host}/rds/catalog/test/view/tabulate?dims=var&measure=average:AVG(var2)

  Average Output Expand source

  {
      "records": [
          [
              1,
              3.1154
          ],
          [
              2,
              3.0932
          ],
          [
              3,
              2.9365
          ]
      ],
      "info": {
          "colCount": 2,
          "format": "MTNA",
          "includeMetadata": false,
          "limit": 20,
          "offset": 0,
          "moreRows": false
      }
  }

• Multiple dimensions and measures can be added by using a comma separated list of variables for each

  Multiple Dimensions and Measures

  {host}/rds/catalog/test/view/tabulate?dims=var1,var2&measure=avg:AVG(var3),avg2:AVG(var4)