...

...

Formatting Tabulations

• In this example we will create a dataProvider object that can be used with amCharts. We will assume that we have a collection named "test" and  and a view named "view" with  with a variable named "var" that  that has the values 1, 2, and 3. In this example we will run a tabulation that will count the frequencies of each of these values that could be used to create a chart.

• Running the tabulation would normally look something like this:

  Code Block
  title 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 } }

  
  

• We can look at some of the formatting changes by running several of the different formats.

  Code Block
  title Pie Chart
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var&format=plotly_pie

  
  

  Code Block
  title Pie Output collapse true
  [ { "values": [ 182, 354, 126 ], "labels": [ "1", "2", "3" ], "type": "pie" } ]

  
  

  Code Block
  title Bar Chart
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var&format=plotly_bar

  
  

  Code Block
  title Bar Output collapse true
  [ { "x": [ 1, 2, 3 ], "y": [ 182, 354, 126 ], "type": "bar" } ]

   

   

• In addition to formatting the values in a Plotly compliant way, we can also substitute the numeric values for the categories they represent if the variable has a classification associated with it. In this example we will assume that var has the following classification:

  1	METROPOLITAN AREA
  2	TOWN OR CITY
  3	OPEN COUNTRY

  
  

  Code Block
  title Pie Chart
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var&format=plotly_pie

  
  

  Code Block
  title Pie Output collapse true
  [ { "values": [ 182, 354, 126 ], "labels": [ "METROPOLITAN AREA", "TOWN OR CITY", "OPEN COUNTRY" ], "type": "pie" } ]

  
  

  Code Block
  title Bar Chart
  http://{host}/rds/api/catalog/test/view/tabulate?dims=var&format=plotly_bar

  
  

  Code Block
  title Bar Output collapse true
  [ { "x": [ "METROPOLITAN AREA", "TOWN OR CITY", "OPEN COUNTRY" ], "y": [ 182, 354, 126 ], "type": "bar" } ]