Versions Compared

Version Old Version 7 New Version Current
Changes made by

Andrew DeCarlo

Andrew DeCarlo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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
    titleBasic Tabulation
    http://{host}/rds/api/catalog/test/view/tabulate?dims=var


    Code Block
    titleTabulation Output
    collapsetrue
     {
    "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
    titleBasic Tabulation
    http://{host}/rds/api/catalog/test/view/tabulate?dims=var&measure=average:AVG(var2)


    Code Block
    titleAverage Output
    collapsetrue
    {
    "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
    titleMultiple Dimensions and Measures
    http://{host}/rds/api/catalog/test/view/tabulate?dims=var1,var2&measure=avg:AVG(var3),avg2:AVG(var4)