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.

Creating Tabulations

• 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. We can do this by specifying the variables we want to use as dimensions with the dims parameter.

  Code Block
  title Basic Tabulation
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var

  
  

  Code Block
  title Tabulation Output collapse true
  { "records": [ [ 1, 182 ], [ 2, 354 ], [ 3, 126 ] ], "info": { "colCount": 2, "format": "MTNA", "includeMetadata": false, "limit": 20, "offset": 0, "moreRows": false } }

  
  

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

  Code Block
  title Basic Tabulation
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var&measure=average:AVG(var2)

  
  

  Code Block
  title Average Output collapse true
  { "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

  Code Block
  title Multiple Dimensions and Measures
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var1,var2&measure=avg:AVG(var3),avg2:AVG(var4)