There are several different types of tables that can be created in Displayr - each with their own particular customizations/features. This article outlines the functionality available for the different types of tables so you can be sure you're choosing the correct one based on your requirements.
For example, suppose you want a table that is a bit more customized than some of our built-in drag/drop tables allow. With a Table > Specialty > Table with Custom Formatting (also known as an Autofit table), you can control the formatting and spacing of the table to align with outputs and give your report a cohesive feel.
You can go from a standard table...
...to a table that can align perfectly with other outputs.
After setting this up in your document, you certainly don't want to be surprised that these Autofit tables export to PPT as an image and not editable text, as your client may require editable tables in PPT.
The table below is designed to help (click on the column headers to see examples). While this is not a complete list of all the special tables that are available in Displayr, they are the most common ones. If you don't see the type of Displayr table you intend to use, spend a few minutes to double-check that it supports all the features you want to use in your report.
| Feature |
(some features may be available via Table Rules) |
Basic Table Built using R |
(specialty Autofit table from above) |
(more customizable Autofit table using custom R code) |
| Export to editable table in Excel | x | x | x | x |
| Export to editable table in PPT | x | x | (exported as image) | (exported as image) |
| Format cells in bulk | x | (using Properties > APPEARANCE) | x | x |
| Applying Filter(s) & Weight | x |
(if creating the table using raw data within R or must be applied to the data source) |
(must be applied to the data source) |
(if creating the table using raw data within R or must be applied to the input table) |
| Show Raw Data | (for a single variable set only) |
Raw Data Table automates this or you can write custom R code |
(using a table of raw data as the DATA SOURCE) |
(using a table of raw data as the input to CreateCustomTable()) |
| Access or work with a STATISTICS > Right or Below | x | |||
| Perform built-in statistical testing | x | |||
| Show built-in statistical testing | x | x | ||
| Shade cells based on values | x | x | ||
| Create spans | x | x (advanced R code) |
||
| Show multiple statistics | x | x | x (advanced R code) |
|
| Merge tables | (can be used as an input to Combine Tables, but not final result) | x | x | |
| Show Rows/Columns/Data based on a Control (combo box dropdown, list box, etc) | x | x | x | |
| Do something based on a different output on the page | x | x | x | |
| Format Row/Column Headers | x | x | ||
| Control alignment and spacing of rows/cols/cells | x | x | ||
| Render embedded HTML (allows for links and images to be displayed) | x | |||
| Add a custom index | x | x | x | x |
| Sort rows | x | x | x | x |
| Hide Rows/Columns if empty or if data doesn't meet threshold | x | x | x | x |
If you're having trouble figuring out what type of table is best for your particular situation, don't hesitate to reach out to our support team through Help > Contact Support from your document with the detail on what you require.
Next
How to Create an Autofit Table
How to Add Statistical Significance to CreateCustomTable R Tables