Configure Tables
Formatting tables is easier and faster in the Properties Panel. Let's learn about the six table formatting options.
This article covers:
- • How Do I Add a Table View?
- • Where Can I Find Table Properties?
- • Table Formatting Options
- • Group Interactions
- • FAQ
How Do I Add a Table View?
Add a Table View to any node in your Dataflow or Data App. Select any node and use the Transform (+) button to open the list of options and select Table View.
To add a Table to a Data App, drag and drop the output of a node to the Data App workspace.
Where Can I Find Table Properties?
Select a table, either in a Dataflow or in a Data App, to see the complete list of table transform properties.
Table Formatting Options
There are six transformation options under the Configuration section in the Properties Panel. If you do not see this, make sure the properties panel is open on the right.
- Hide Columns
- Filter
- Sort
- GroupBy
- Reorder columns
- Format Numbers
There is a number in a parenthesis that indicates how many fields are being edited for each transformation. The table is grouped by one field in the example below - shown byGroup by (1).
1. Hide Columns
Use the dropdown to select one or many columns to hide in your table. To quickly deselect all columns, click the none option in the dropdown.
2. Filter
Click the OR button to change the filter operator to AND, and vice versa to switch back to OR. Use the +Add Condition button to create more filter conditions, and click the "x" button to the right of each dropdown to remove a condition.
3. Sort
Use the Sort dropdown to select a field. Click on the button to the right of the dropdown to switch from ascending to descending. Use the +Add Sort button to create multiple sorting conditions and click the "x" button to the left of each dropdown to remove a condition.
4. Group by
Use the Group by dropdown to select a field. Use the +Add Column button to create multiple groups and click the "x" button to the right of each dropdown to remove a group.
5. Reorder Columns
Use the Column dropdown to select a field and the Order By dropdown to pick which order to place the selected column. Use the second Column dropdown to choose a reference column for the options "Before" or "After".
Use the +Reorder Another button to create multiple groups and click the "x" button to the right of each dropdown to remove a condition.
6. Format Numbers
Use the Column dropdown to select a field, and the Unit dropdown to choose a number format. You could specify the number of decimal places by typing in the Decimal places textbox.
Use the +Format Another button to select more columns and click the "x" button to the right of each dropdown to remove a condition. Each column you format can have its own unique format options.
Group Interactions
This section in the Properties Panel lets you select a type of data interactivity for your table. Interactions are set by default; however, you could remove this by unchecking the Allow Interactions box.
Cross-filtering (default) will reduce a table and show only the records that match a selection made in a chart within the same Data App. Cross-highlighting will highlight records in a table.
FAQ
1. Can I edit table formatting?
Absolutely! Open the Properties Panel to add and remove formatting option. Each table will maintain its unique configuration.
Check out the links below for related articles:
