Versions Compared

Version Old Version 3 New Version 4
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.

    Code Block
    titleBasic Tabulation
    {host}/rds/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, fill out the measure parameter with a computed variable.

    Code Block
    titleBasic Tabulation
    {host}/rds/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
    {host}/rds/catalog/test/view/tabulate?dims=var1,var2&measure=avg:AVG(var3),avg2:AVG(var4)