Each built-in Displayr table has associated meta-data available to R under the hood. These attribute parameters can be called via R using the *attributes* command, see How to Extract Information from an R Object. Some of these attributes include statistic (the statistics shown), spans and other labels in the table, base information, and stat testing info. When performing R table calculations, there will be times when these attributes will carry over to your custom tables, but you may wish to alter some of them or add them back in.

One common example is to change the statistic of an R table to a percentage statistic so the data is plotted as % in a visualization. This article describes how to update the *statistic** attribute* in an R table from Count:

to %:

## Requirements

- A basic table created in R (not a table created with an R function like CreateCustomTable() or DT()).

## Method

For this example, we will use the following two tables to calculate a new R table (*pref* below) of preference based on awareness:

1. Select **Calculation > Custom Code** and draw a box on the **Page.**

2. Paste the below under **Properties > R CODE**:

#calculate preference based on awareness

pref = table.preference / table.awareness * 100

Because the source tables (above) are both using **Count**, the final result also shows as **Count **in the column header and we can't add a % symbol.

3. To change the underlying statistic, we can use the *attr* command and then return our updated *pref* table, add the following code to the bottom of the code above:

#set the statistic attribute to % for the new table

attr(pref,"statistic") = "%"

#return the final table in the output

pref

4. Press the **%** symbol under **Properties > APPEARANCE > Number format **and the table will display as expected.

## Notes

We can confirm the* attribute* parameters in the original R table by calling the following:

#see all the attributes of the table

attributes(pref)

Here, you'll see the *statistic* parameter was changed to %. You can see other attributes available that you can use in other custom R code.

## Next

Creating and Modifying Visualizations

How to Add Row Spans to a CreateCustomTable R Table

How to Use Paste Functions to Create Dynamic Text Using R

How to Add Statistical Significance to CreateCustomTable R Tables

How to Work with R in Displayr

How to Extract Information from an R Object

## Comments

0 comments

Article is closed for comments.