Improvements to Tables Created by R in Calculations - What’s Changed and Why – Displayr Help

We have made the following improvements to tables created by Calculations to make them more consistent with other types of tables in Displayr. These changes impact basic tables created by R in Calculations and not custom formatted tables created by CreateCustomTable.

Existing R Calculations/tables will automatically upgrade in March 2024
Upgrading Calculations to the new format
Calculation tables take up all available space
Significance testing is retained in calculation tables that reference standard drag-and-drop source tables
Filter icons in columns and rows are only visible on hover or when activated
Navigation tools for tables that won't fit on a single page
Exporting a Paginated Table Created by a Calculation

The following table will serve as the basis for most of the examples included in this article:

Existing R Calculations/tables will automatically upgrade in March 2024

Going forward, you will receive a warning notice that all existing R Calculations/tables will automatically upgrade to the new format in March 2024. This notice will appear at the top of the Object Inspector on the right.

At that time, any existing tables/outputs will change to the new version, meaning that anything with a bounding box larger than the table itself will stretch out and cover more space. Manually upgrading the calculations in advance of the automatic change will help you avoid any issues.

Upgrading Calculations to the new format

To upgrade any calculations in your document to the new format, select a calculation and click one of the buttons in the prompt at the top-right of the object inspector. You can upgrade only the selected calculation by clicking Upgrade or upgrade all of the calculations in the document by clicking Upgrade all tables in this document.

Calculation tables now take up all available space

Tables are automatically stretched to fill all available space it has available. For example, suppose you want to extract the first row from the above table and display it in a calculation.

Significance testing is retained in calculation tables that reference standard drag-and-drop source tables

Calculation tables that are derived from standard tables will automatically retain the significance testing from those tables:

In addition, you can also change the appearance of the arrows or remove them, just like you can in a standard drag-and-drop table.

For example, here is the same table with the arrows but without the different font colors:

Filter icons in columns and rows are only visible on hover or when activated

In prior versions of Displayr, filter icons in columns and rows were visible even before they were applied.

For example:

After the upgrade, these icons will only show on hover or after you apply the filter. This change is designed to make the table cleaner and easier to read.

For example:

Navigation tools for tables that won't fit on a single page

If a table is too long to display on a single page, the navigation tools below the table will be smaller and less noticeable than they were before.

Exporting a Paginated Table Created by a Calculation

While it is possible to create a table using a calculation where the number of rows exceeds what can be shown on the page, whenever you use one of the following three options, only the rows that are visible on the page will be exported: