You can customize your tables for export or usage on a dashboard by hiding rows/columns, reordering rows/columns, and editing labels.
The following describes how to enable this feature with the Crunch web app.
How to customize your tables for export or dashboards
You’ve already been able to customize saved graphs, but now you can make those same edits to the rows and columns of saved tables, either for export or for display in dashboards. For example, you can:
- Hide any rows and/or columns of a table, including calculated rows/columns such as subtotals, leaving only those you want your export/dashboard consumers to see. Simply uncheck the box next to the row/column to hide it.
- Reorder the rows/columns of a table, just by dragging them into their new order.
- Rename any row/column just by typing into the name box. This is ideal for cases in which the labels are too long or contain unwanted content.
Together, these features allow you to turn off rows and columns in ‘messy’ tables. For example, the following table has many columns that the researcher may not want to display in the analysis. They may want to instead focus the viewer’s attention on what’s most important:
The result is something like the following, which is much neater:
The action here simply hides the rows and columns in the table; the original variable is unaffected (so if you made another table, you would see all the columns/rows again).
All users can access this new functionality by clicking the “edit” link shown upon hover of each slide saved to the deck:
Editors can additionally access this functionality when editing dashboard tiles that contain tables.
The following video walks you through the steps for adding a table to your deck and then how to edit that table to only show the rows and columns of interest, arranged in the desired order:
We welcome your feedback at email@example.com.